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
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.
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
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.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.