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)
--
View this message in context:
http://www.nabble.com/Read-SAS-data-into-R-tf3723790.html#a10434169
Sent from the R help mailing list archive at Nabble.com.
______________________________________________
[email protected] 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.
