Florio,

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 views?

Art ---------- On Mon, 16 Jul 2007 18:41:09 -0400, Florio Arguillas <foa2@CORNELL.EDU> wrote:

>Dear SAS-L, > >I am posting the question below for my colleague. > >Thanks in advance for your help. > >Florio > >The Question: > > >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.