[R] Read SAS data into R
liuwensui at gmail.com
Fri May 11 21:52:21 CEST 2007
not necessarily, if R can access SAS data through SAS ODBC driver. I
do so for *.sav data all the time.
On 5/11/07, Frank E Harrell Jr <f.harrell at vanderbilt.edu> 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).
> Frank E Harrell Jr Professor and Chair School of Medicine
> Department of Biostatistics Vanderbilt University
> R-help at stat.math.ethz.ch mailing list
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
A lousy statistician who happens to know a little programming
More information about the R-help