Building models with SAS Enterprise Miner, SAS Factory Miner, SAS Visual Data Mining and Machine Learning or just with programming

How do I import data from Microsoft SQL Server to SAS Enterprise Miner v13.2?

Reply
Regular Learner
Posts: 1

How do I import data from Microsoft SQL Server to SAS Enterprise Miner v13.2?

Hi,

 

I am using SAS Enterprise Miner version 13.2 and trying to import a large data table (about 20GB) from Microsoft SQL Server to SAS Enterprise Miner.  I tried two methods but neither worked for me.

 

Method 1: First save SQL server data in a csv file and then use File Import Node in SAS. The size of data is a problem. The query in SQL failed when I try to select all 20GB data in that table. This method did work if I only select part of the data (ex. first 10,000 rows)

 

Method 2: Create a library in SAS that points to the SQL database. The IT team in our company helped me create a library but I can't see it in SAS Enterprise Miner library list. Unfortunately, the IT team doesn't know how to connect SAS and SQL server.

 

Does anyone know how to import large amount of data from Microsoft SQL Server to SAS Enterprise Miner?

 

Thanks a lot

Albert

Super User
Posts: 3,112

Re: How do I import data from Microsoft SQL Server to SAS Enterprise Miner v13.2?

Normally you use a SAS product like SAS/ACCESS to SQL Server or SAS/ACCESS to ODBC. Do you have either of these? If you don't know check with your SAS admin or run this code - proc setinit; run; - to see if they are included in your SAS licence. 

Ask a Question
Discussion stats
  • 1 reply
  • 250 views
  • 1 like
  • 2 in conversation