search for: fund_style

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...