At 11:43 AM 3/13/2009, Bill Niehaus wrote:
Has anyone used PROC SQL in SAS to read information from an
RBase database?
I currently generate ASCII files from RBase and then use SAS
to read the ASCII files. I am just looking into options to
read the most current data from RBase.
Bill,
Using SAS's toolbox you should be able to pull live data from
sources outside of SAS using the 3.0 compliant ODBC driver of
R:BASE, such as Oterro 4.0 for .rb1 or Oterro 8.0 for .rx1
databases.
All you need to do is create a System DSN for your R:BASE
database in question, using the Oterro ODBC driver. Once the
System DSN is defined accordingly, with proper permissions
(user rights), you should be able to work in a live environment.
Should you require further assistance, feel free to ask.
Very Best R:egards,
Razzak.
