02-02-2017 05:00 PM
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
02-03-2017 03:38 AM
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.