topic Re: Accessing SAS Data via API (or Other Tool) SAS 9.1.3 Integration Technologies in SAS Programming

Accessing SAS Data via API (or Other Tool)

ASmithBexar — Wed, 17 Oct 2018 22:41:37 GMT

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?

Re: Accessing SAS Data via API (or Other Tool) SAS 9.1.3 Integration Technologies

ChrisNZ — Thu, 18 Oct 2018 01:04:46 GMT

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.

Re: Accessing SAS Data via API (or Other Tool) SAS® Add-In for Microsoft Office

ChrisNZ — Thu, 18 Oct 2018 01:06:43 GMT

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

Re: Accessing SAS Data via API (or Other Tool) SAS 9.1.3 Integration Technologies

ASmithBexar — Tue, 23 Oct 2018 13:45:25 GMT

This is very helpful, thanks.