BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
ANLYNG
Pyrite | Level 9

Has anyone experience loading data from MS SQL 2016 server from SAS 9.4 M2? On the SAS support pages it says that we need to run at least SAS 9.4 M3! But how can we do that easy? I presume that the whole environment should be upgraded then?

 

Thanks in  advance.

1 ACCEPTED SOLUTION

Accepted Solutions
SASKiwi
PROC Star

If you are running SAS 9.4M2 on Windows then SAS Support gave you the correct answer. SAS only started supporting the Windows platform for SAS/ACCESS to SQL Server from 9.4M3. Under Unix, earlier SAS versions of SAS/ACCESS to SQL Server are available.

 

If you want to stay with SAS 9.4M2 (upgrading can be costly and time consuming) and you are running on Windows then you could use SAS/ACCESS to ODBC with SQL Server instead. This is what we use and performance is excellent.

View solution in original post

6 REPLIES 6
anja
SAS Employee

Hi,

 

yes, M3 is needed to support MS SQL 2016 Server.

 

For information on upgrading to a new maintenance release, please see

http://support.sas.com/software/maintenance/index.html

 

Hope that helps

Thanks

Anja

ANLYNG
Pyrite | Level 9

so we need to upgrade the whole installation and can not add one component whivh os newer?

SASKiwi
PROC Star

Correct. All products in your SAS installation need to be on the same maintenance release to ensure compatibility.

PaulOK01
Fluorite | Level 6

Hi, we access our SQL Server 2016 database with SAS 9.3 (TS1M2) on AIX 7.1.

 

What situation requires you to have SAS 9.4?  Where did you read this in the documentation?

 

Paul

ANLYNG
Pyrite | Level 9

It sounds interesting. What interface do you use - is it SAS/ACCESS interface to Microsoft SQLserver?

 

We run sas 9.4M2 and sas support told me that we needed to upgrade to at least 9.4M3 and gave me this link:

http://www.google.dk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&cad=rja&uact=8&ved=0ahUKEwjB5rXwoY3TAh...

 

SASKiwi
PROC Star

If you are running SAS 9.4M2 on Windows then SAS Support gave you the correct answer. SAS only started supporting the Windows platform for SAS/ACCESS to SQL Server from 9.4M3. Under Unix, earlier SAS versions of SAS/ACCESS to SQL Server are available.

 

If you want to stay with SAS 9.4M2 (upgrading can be costly and time consuming) and you are running on Windows then you could use SAS/ACCESS to ODBC with SQL Server instead. This is what we use and performance is excellent.

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
  • 6 replies
  • 3237 views
  • 0 likes
  • 4 in conversation