01-11-2017 05:40 AM
I'm using SAS 9.3 . How can i conect form Base SAS to SQL server in order to see or import SQL tables into SAS.
---Base SAS Software
---MDDB Server common products
---SAS Enterprise Guide
---SAS/ACCESS Interface to PC Files
---SAS Workspace Server for Local Access
01-11-2017 05:57 AM
Actually, I don't think that the SQL Server engine is supported any more. Users (at least in Windows) are directed to ODBC or OLEDB.
So you need to extend your licence/installation with an ACCESS to ODBC/OLEDB product.
01-11-2017 06:19 PM
You can use your SAS/ACCESS Interface to PC Files to read and write to a SQL Server database. See the bottom of page 213 of the "SAS/Access 9.4 Interface to PC Files: Reference, Fourth Edition", http://support.sas.com/documentation/cdl/en/acpcref/69731/PDF/default/acpcref.pdf
01-13-2017 02:21 PM
There are a number of things to setup to establish the link to the database. Here's a post that lists what needs to be done:
01-13-2017 05:35 PM
The PC Files Server needs to be installed. It is available as a download from SAS: