[R] Read SAS data into R

Wensui Liu 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
> 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.
>


-- 
WenSui Liu
A lousy statistician who happens to know a little programming
(http://spaces.msn.com/statcompute/blog)



More information about the R-help mailing list