Has anyone been able to successfully query SAS libraries from R using RODBC? While I believe I have configured the SAS ODBC Driver properly (I can query SAS libraries from MS Access) when I try to query SAS libraries from R, I only seem to get back the column names of the table I am querying. Sample Code:
> # open connection to SAS library 'Common' > conn = odbcConnect('Common') > # query test table I made in SAS > mytable = sqlQuery(conn, 'select * from Common.Mydata') > # mytable only has the names of the the Common.Mydata Dataset, it did not > # retrieve the values > mytable [1] var1 var2 var3 <0 rows> (or 0-length row.names) Thanks for your help. -Mike King [[alternative HTML version deleted]] ______________________________________________ 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.