topic Re: SQL Server Tables into SAS in SAS Data Management

SQL Server Tables into SAS

DejanPeeski — Wed, 11 Jan 2017 10:40:29 GMT

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

Re: SQL Server Tables into SAS

RW9 — Wed, 11 Jan 2017 10:50:35 GMT

Google response no 2:

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

Re: SQL Server Tables into SAS

LinusH — Wed, 11 Jan 2017 10:57:04 GMT

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.

Re: SQL Server Tables into SAS

PaulOK01 — Wed, 11 Jan 2017 23:19:10 GMT

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

Re: SQL Server Tables into SAS

DejanPeeski — Fri, 13 Jan 2017 09:48:23 GMT

I get an

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

Re: SQL Server Tables into SAS

PaulOK01 — Fri, 13 Jan 2017 19:21:56 GMT

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-University-Edition/m-p/273857/highlight/true#M3724

Paul

Re: SQL Server Tables into SAS

SASKiwi — Fri, 13 Jan 2017 22:35:41 GMT

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#n1gkwhppdxw1bsn1w447teakcjrv.htm