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]]