Displaying 1 result from an estimated 1 matches for "cancer_type".
Did you mean:
canceltype
2012 Oct 30
1
sqlFetch doesn't read the whole objects.
...from R?
Thank you in advance.
EJ
> psb<-odbcConnect("PSB",uid="XXX",pwd="XXXXXXX")
> cancers<-sqlFetch(psb,"CANCERS")
> str(cancers)
'data.frame': 600 obs. of 5 variables:
$ study_id : int 7 152 11 12 3 14 16 22 23 24 ...
$ cancer_type: Factor w/ 121 levels " Breast cancer ",..: 15 24 65 NA 45 16
73 46 23 66 ...
$ cancer_age : Factor w/ 70 levels "17","1968","1983",..: NA 14 31 NA 58 NA
NA 38 NA 35 ...
$ cancer_recs: num 656 656 656 656 656 656 656 656 656 656 ...
$ cancer_year: Factor...