Re: [R] SAS ODBC

2008-02-05 Thread Scillieri, John
That did it, thanks. -Original Message- From: Prof Brian Ripley [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 05, 2008 4:28 PM To: Scillieri, John Cc: [EMAIL PROTECTED] Subject: Re: [R] SAS ODBC See the help page for odbcConnect. I have no experience with that ODBC driver, but a

Re: [R] SAS ODBC

2008-02-05 Thread Prof Brian Ripley
See the help page for odbcConnect. I have no experience with that ODBC driver, but a few contain errors and need believeNRows = FALSE. On Tue, 5 Feb 2008, Scillieri, John wrote: > All, > > I'm trying to connect to a remote SAS server using SAS's 9.1 ODBC driver > and the RODBC package. I'm runn

[R] SAS ODBC

2008-02-05 Thread Scillieri, John
All, I'm trying to connect to a remote SAS server using SAS's 9.1 ODBC driver and the RODBC package. I'm running R-2.6.1 on Win XP. I can successfully connect to the database, but no matter which table I query, I get back an empty table with only the column headers. For example: > sqlQuer

[R] SAS ODBC DRIVER

2007-10-31 Thread Michael King
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. Sampl