Date: Mon, 16 Jul 2007 19:35:07 -0400
Reply-To: Arthur Tabachneck <art297@NETSCAPE.NET>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Arthur Tabachneck <art297@NETSCAPE.NET>
Subject: Re: R to SAS interface
While I haven't tried the ODBC interface that Dan suggested, I did notice
that you mentioned a SAS "database".
Unless I've missed something, SAS doesn't offer a database, per se, but
only an equivalent of flat files.
If your current database contains more than one table, I think you might
want to rethink what you are trying to suggest. You do know that SAS has
an Access to Oracle addon that allows one to read Oracle databases and
On Mon, 16 Jul 2007 18:41:09 -0400, Florio Arguillas <foa2@CORNELL.EDU>
>I am posting the question below for my colleague.
>Thanks in advance for your help.
>Suppose I have an application that currently uses NO SAS at all, but
>interfaces with a SQL database:
> application <-> SQL database (MySQL, Oracle)
>I now want to replace the SQL database with SAS, but keep the
>application general enough - i.e., have it use SQL queries, but against
>a SAS database.
>How would I need to set that up?
>The particular context I am thinking about is a R-SAS interface. There
>is a R module to interface directly with SQL databases. If it were
>possible to have SAS present a SQL interface, then it might be a lot
>easier to do the interface.