BookmarkSubscribeRSS Feed
A_Kh
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/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! 


 .  

4 REPLIES 4
Morse_Bill
Obsidian | Level 7

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

SASKiwi
PROC Star

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

proc product_status;
run;
A_Kh
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
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
SASKiwi
PROC Star

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
  • 363 views
  • 2 likes
  • 3 in conversation