[R] Connecting R to SAS SPDS through ODBC - no results.

[Charles Burchill]

We have recently setup our SAS SPDS data server for use with ODBC connections.

Unfortunately when sending a query to the data server I am getting no data returned.  It is not clear if this is an issue with SPDS or RODBC and I am hoping someone has explored this already.



I know the connection works since I can query data through MS Access/Excel, or STATA and have data returned.



odbcConnect(ch)  - works fine.

odbcGetInfo(ch) - returns the server information



sqlTables()  returns no table information

sqlQuery()  returns the file structure but no records.

sqlFetch()  doesn't find the table (although an sqlQuery obviously does since it returns structure information)



I am hoping that someone can send me an example of accessing SPDS through ODBC using R.



Thanks!





--
Charles Burchill, Associate Director Data Access and Use,
Manitoba Centre for Health Policy
College of Medicine, Faculty of Health Sciences
408-727 McDermot Ave, winnipeg, Manitoba, R3E 3P5
Tel: 204 789 3429  Fax: 204 789 3910
Charles.Burchill at umanitoba.ca<mailto:Charles.Burchill at med.umanitoba.ca>

	[[alternative HTML version deleted]]