BookmarkSubscribeRSS Feed
Lapis Lazuli | Level 10

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/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 and couldn't figure it out from there.

Any practical advice would be very much appreciated. 

Thank you! 


Obsidian | Level 7

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

Opal | Level 21

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

proc product_status;
Lapis Lazuli | Level 10
For Base SAS Software ...
   Custom version information: 9.4_M5
   Image version information: 9.04.01M5P090617
For SAS/STAT ...
   Custom version information: 14.3
   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
Opal | Level 21

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.

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 3 in conversation