Hi , I want to extract data from SQL Server. I successfully connect my computer with SQL Server by ODBC . Then I run proc sql to extract data from one table in SQL Server database:P_2013. The SAS log showed me that it took ~40 min for extracting the data. To save time, I run the same SAS program in three computers simultaneously to extract data from other tables of the same database:P_2013. The SAS log surprisingly showed that it took ~130 min for extracting the data, about three times as one computer . No time was saved at all! Would you please suggest me how to save time to extract data from the tables of the same database in SQL Server ?
... View more