topic Re: Is it possible to read SAS view or data from outside SAS? in SAS Enterprise Guide

Is it possible to read SAS view or data from outside SAS?

gabras — Thu, 13 Sep 2018 17:19:56 GMT

Hi,

i need some help about the possibility of extracting SAS data from outside SAS.

I have to create three sas view that my Customer has to execute and read when he wants. Theese views will be stored in Sql server.

Does anyone know how it can be done?

Thank you

Re: Is it possible to read SAS view or data from outside SAS?

ChrisHemedinger — Thu, 13 Sep 2018 17:31:00 GMT

To be clear, you're reading non-SAS data (SQL server) from a SAS process? Yes, you can do that.

Assuming that you have SAS/ACCESS to ODBC or SAS/ACCESS to OLE DB, you assign a SAS library to your database connection. Exact syntax for this may vary, but it will look something like this:

libname mydblib oledb 
 user=myusr1 password=mypwd1
 datasource=dept203 provider=sqloledb 
 properties=('initial catalog'=mgronly);

Then you can access the tables/views with normal LIBNAME.MEMBER syntax (ex: mydblib.mydata).

See documentation here for OLE DB. And here for ODBC.

Re: Is it possible to read SAS view or data from outside SAS?

gabras — Thu, 13 Sep 2018 19:01:24 GMT

Hi @ChrisHemedinger

unfortuntely not.

It's the opposite. The customer has to read a sas data from outside SAS.

Pippo Company has to read the SAS view and bring it on its db.

Thank you

Re: Is it possible to read SAS view or data from outside SAS?

ChrisHemedinger — Thu, 13 Sep 2018 19:13:59 GMT

Okay -- for that, we have the SAS IOM Provider for OLE DB (use this to connect to a SAS workspace, similar to the way SAS Enterprise Guide works) and the SAS ODBC Driver (connects to SAS/SHARE server or SPDS server). Either way, I think to render a SAS view you'll need the driver to connect to a running instance of SAS that can assemble the data rows, with any SAS formats you need, etc.