SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

SQL Server Tables into SAS

Reply
Occasional Contributor
Posts: 7

SQL Server Tables into SAS

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
                    

Super User
Super User
Posts: 7,401

Re: SQL Server Tables into SAS

Super User
Posts: 5,257

Re: SQL Server Tables into SAS

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. 

Data never sleeps
Occasional Contributor
Posts: 7

Re: SQL Server Tables into SAS

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

Occasional Contributor
Posts: 7

Re: SQL Server Tables into SAS

I get an

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

Occasional Contributor
Posts: 7

Re: SQL Server Tables into SAS

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

Super User
Posts: 3,106

Re: SQL Server Tables into SAS

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...

 

Ask a Question
Discussion stats
  • 6 replies
  • 235 views
  • 0 likes
  • 5 in conversation