Accessing SAS Data via API (or Other Tool)

[ASmithBexar]

We recently migrated to SAS v9.4 and have started to use some new tools, such as SAS/ACCESS to SQL. We started using this tool to access a SQL database and import data tables into SAS. However, we have been asked whether there are tools available for third party systems (whether custom or COTS) to access SAS data tables (to connect into SAS rather than have SAS connect into other systems). One example would be an API. For example, are there SAS APIs that another system could call to retrieve data from our SAS data tables?

[ChrisNZ · Accepted solution]

The most common way to to use the SAS ODBC Driver.

This requires SAS/SHARE to be licensed.

A JDBC driver also exists for Java applications.

CORBA can also be used via SAS's IOM interface and requires SAS/Integration Technologies to be licensed.

If you use .NET, this could be useful to read.

[ASmithBexar]

This is very helpful, thanks.

[ChrisNZ]

If you simply want access from MS Office, the SAS Add-In for Microsoft Office might be sufficient.