Re: [R] Read SAS data into R On Fri, 2007-05-11 at 13:43 -0500, Frank E Harrell Jr wrote:> kseefeld wrote:> > Kimâs EZ Recipe forâ¦.> > > > SAS TO R, perfectly formatted table with no loss of data> > > > â¢	In SAS: Export SAS DB as access db> > â¢	In R go to directory where access db is stored> > â¢	Use package RODBC> > > > #R code> > #Create connection object (Can set up DSN but Iâm too lazy to)> > c<-odbcConnectAccess("x.mdb")> > #Create table object, store db in object> > x<-sqlFetch(c, "test")> > #Close connection object> > odbcClose(c)> > > > > > That doesn't help people who don't have SAS.> > Note that an upcoming release of the Hmisc package has a new Access > import function for users who have access to the mdbtools package on > their operating system (e.g., linux). mdbtools is also being used by the OO.org folks:   http://dba.openoffice.org/drivers/mdb/index.html Just to follow up on Frank's prior post regarding the SAS System Viewer,that does work well under Wine on Linux, with the caveat that Franknotes. I also use DBMS/Copy under Wine and that works quite well. One of the advantages of DBMS/Copy versus the System Viewer is widersupport for the proprietary SAS formats from various OSs. We recentlywere in receipt of SAS datasets that were generated on a 64 bit Unixplatform. The SAS System Viewer choked on them, but DBMS/Copy had noproblem. The SAS System Viewer is a free download, whereas DBMS/Copy is not, soit places an emphasis on either getting SAS datasets from Windows basedinstallations or ensuring that the entity generating the datasetsoutputs SAS Transport format files instead. HTH, Marc Schwartz ______________________________________________R-help@stat.math.ethz.ch mailing listhttps://stat.ethz.ch/mailman/listinfo/r-helpPLEASE do read the posting guide http://www.R-project.org/posting-guide.htmland provide commented, minimal, self-contained, reproducible code.