topic Re: How to connect SAS to SQL Server: is any initial set up process needed? in Administration and Deployment

How to connect SAS to SQL Server: is any initial set up process needed?

A_Kh — Tue, 24 Jan 2023 17:06:28 GMT

Hello Community,

I need some advices on how to set up the connection to SQL Server from my SAS. What is needed to know for this setup?

SAS version: 9.04.01M5P091317.

Operating System: W32_WKS.

SAS components include (from proc setinit):

---Base SAS Software
---SAS/STAT
---SAS/GRAPH
---SAS/Secure 168-bit
---SAS/Secure Windows
---SAS Enterprise Guide
---SAS Workspace Server for Local Access
---High Performance Suite

I know SQL path- through facility enables me to access data in external databases. I believe there are some steps (system set up I mean) that I need to complete, or system requirements my SAS must have in order to be able to use this facility.

I've checked documentation.sas and couldn't figure it out from there.

Any practical advice would be very much appreciated.

Thank you!

Re: How to connect SAS to SQL Server: is any initial set up process needed?

Morse_Bill — Tue, 24 Jan 2023 17:17:50 GMT

Looks like you'll need a SAS/Access engine -- SAS/Access to ODBC or SAS/Access to SQL Server.

Re: How to connect SAS to SQL Server: is any initial set up process needed?

SASKiwi — Tue, 24 Jan 2023 18:59:56 GMT

What products are installed? Run this and post the output:

proc product_status;
run;

Re: How to connect SAS to SQL Server: is any initial set up process needed?

A_Kh — Tue, 24 Jan 2023 20:07:08 GMT

For Base SAS Software ...
   Custom version information: 9.4_M5
   Image version information: 9.04.01M5P090617
For SAS/STAT ...
   Custom version information: 14.3
For SAS/GRAPH ...
   Custom version information: 9.4_M5
For High Performance Suite ...
   Custom version information: 2.2_M6
NOTE: PROCEDURE PRODUCT_STATUS used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds

Re: How to connect SAS to SQL Server: is any initial set up process needed?

SASKiwi — Tue, 24 Jan 2023 20:22:21 GMT

OK, that confirms that you have no SAS/ACCESS product either installed or licensed. You will need to follow @Morse_Bill 's advice to enable SAS to read SQL Server databases.