search for: crspfundno

Displaying 2 results from an estimated 2 matches for "crspfundno".

Did you mean: crsp_fundno
2010 Mar 30
1
dataframe in loop
...thank those who helped me out of the string problem..but now 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...
2010 Mar 24
3
string problems in R
...d met a problem that bothered me for a while due to my lack of 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 e...