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.burch...@umanitoba.ca<mailto:charles.burch...@med.umanitoba.ca> [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see 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.
