SQL Server Tables into SAS

[DejanPeeski]

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.

proc setinit;
run;

---Base SAS Software
                    
---SAS/STAT
                    
---SAS/GRAPH
                    
---SAS/ETS
                    
---SAS/FSP
                    
---SAS/AF
                    
---SAS/IML
                    
---SAS/CONNECT
                    
---SAS/INSIGHT
                    
---SAS/EIS
                    
---MDDB Server common products
                    
---SAS Enterprise Guide
                    
---SAS/ACCESS Interface to PC Files
                    
---SAS/IML Studio
                    
---SAS Workspace Server for Local Access
                    

[RW9]

Google response no 2:

https://support.sas.com/techsup/technote/ts765.pdf

[LinusH]

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. 

[PaulOK01]

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

Paul

[DejanPeeski]

I get an

ERROR: Unable to locate pcfserver.exe. Please install PC Files Server.

[PaulOK01]

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:

https://communities.sas.com/t5/SAS-Analytics-U/Connect-to-SQL-Server-Oracle-Database-by-SAS-Universi...

Paul

[SASKiwi]

The PC Files Server needs to be installed. It is available as a download from SAS:

http://support.sas.com/documentation/cdl/en/pcfsicg/69732/HTML/default/viewer.htm#n1gkwhppdxw1bsn1w4...