Displaying 2 results from an estimated 2 matches for "fund_style".
2010 Mar 30
1
dataframe in loop
...I got another problem.
I used R to query from SQL and got a list of crsp_fundno of G-style mutual
funds which is still alive. I use the following codes and got what I want:
library(RODBC)
channel<-odbcConnect("CRSPFUND")
g.crspfundno<-sqlQuery(channel,"select crsp_fundno from Fund_style where
wbrger_obj_cd = 'G'order by crsp_fundno")
g.crspfundno (got crsp_fundno of G-style fund from Fund_style table)
y.crspfundno<-sqlQuery(channel,"select crsp_fundno from Fund_hdr where
dead_flag
= 'N'and end_dt=20091231 order by crsp_fundno")
y.crspfundno (got...
2010 Mar 24
3
string problems in R
...acquaintance of R.
I am using R to query from SQL. I got a list of crsp_fundno of G-style mutual
funds which is still alive. I use the following codes and got what I want:
library(RODBC)
channel<-odbcConnect("CRSPFUND")
g.crspfundno<-sqlQuery(channel,"select crsp_fundno from Fund_style where
wbrger_obj_cd = 'G'order by crsp_fundno")
g.crspfundno (got crsp_fundno of G-style fund from Fund_style table)
y.crspfundno<-sqlQuery(channel,"select crsp_fundno from Fund_hdr where dead_flag
= 'N'and end_dt=20091231 order by crsp_fundno")
y.crspfundno (got c...