Not reproducible, not even close. Other than saying 600 is not a magic limit in R, not much help can be given. --------------------------------------------------------------------------- Jeff Newmiller The ..... ..... Go Live... DCN:<jdnew...@dcn.davis.ca.us> Basics: ##.#. ##.#. Live Go... Live: OO#.. Dead: OO#.. Playing Research Engineer (Solar/Batteries O.O#. #.O#. with /Software/Embedded Controllers) .OO#. .OO#. rocks...1k --------------------------------------------------------------------------- Sent from my phone. Please excuse my brevity.
happyji <e...@bcm.edu> wrote: >Hi everyone, > >I connected a data in FileMaker server with odbcConnect. >When I call the data "CANCERS" using sqlFetch, it looks okay. >However, the number of obs was different with the actual number. >If I read the same data from Microsoft Access, there are 656 obs. in it >but >srt() shows me 600 obs. > >Does anyone know why this happened and how to read all obs. 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 w/ 43 levels "1/2003","12/05",..: 34 34 NA 34 NA >34 >26 NA 34 34 ... > > > > >-- >View this message in context: >http://r.789695.n4.nabble.com/sqlFetch-doesn-t-read-the-whole-objects-tp4647943.html >Sent from the R help mailing list archive at Nabble.com. > >______________________________________________ >R-help@r-project.org mailing list >https://stat.ethz.ch/mailman/listinfo/r-help >PLEASE do read the posting guide >http://www.R-project.org/posting-guide.html >and provide commented, minimal, self-contained, reproducible code. ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.