topic Re: Read data from SQL server in SAS Programming https://communities.sas.com/t5/SAS-Programming/Read-data-from-SQL-server/m-p/384431#M91799 <P>Thank you!</P> Mon, 31 Jul 2017 20:36:11 GMT Visiting 2017-07-31T20:36:11Z Read data from SQL server https://communities.sas.com/t5/SAS-Programming/Read-data-from-SQL-server/m-p/384420#M91790 <P>How can I directly import data from SQL server to SAS? Is there sample code? Thank you!</P> Mon, 31 Jul 2017 20:04:46 GMT https://communities.sas.com/t5/SAS-Programming/Read-data-from-SQL-server/m-p/384420#M91790 Visiting 2017-07-31T20:04:46Z Re: Read data from SQL server https://communities.sas.com/t5/SAS-Programming/Read-data-from-SQL-server/m-p/384429#M91797 <P>First you need to connect to SQL and that depends on your system set up.&nbsp;</P> Mon, 31 Jul 2017 20:26:11 GMT https://communities.sas.com/t5/SAS-Programming/Read-data-from-SQL-server/m-p/384429#M91797 Reeza 2017-07-31T20:26:11Z Re: Read data from SQL server https://communities.sas.com/t5/SAS-Programming/Read-data-from-SQL-server/m-p/384430#M91798 <P>you can do this by defining libname as shown below or by doing explicit pass through</P> <P>LIBNAME SQL ODBC DSN=’sql server’ user=sasjlb pw=pwd;</P> <P>&nbsp;</P> <P>Below two papers will be to give lot of info on this</P> <P><A href="https://support.sas.com/techsup/technote/ts765.pdf" target="_blank">https://support.sas.com/techsup/technote/ts765.pdf</A></P> <P><A href="http://analytics.ncsu.edu/sesug/2002/DM10.pdf" target="_blank">http://analytics.ncsu.edu/sesug/2002/DM10.pdf</A></P> <P>&nbsp;</P> Mon, 31 Jul 2017 20:26:19 GMT https://communities.sas.com/t5/SAS-Programming/Read-data-from-SQL-server/m-p/384430#M91798 kiranv_ 2017-07-31T20:26:19Z Re: Read data from SQL server https://communities.sas.com/t5/SAS-Programming/Read-data-from-SQL-server/m-p/384431#M91799 <P>Thank you!</P> Mon, 31 Jul 2017 20:36:11 GMT https://communities.sas.com/t5/SAS-Programming/Read-data-from-SQL-server/m-p/384431#M91799 Visiting 2017-07-31T20:36:11Z Re: Read data from SQL server https://communities.sas.com/t5/SAS-Programming/Read-data-from-SQL-server/m-p/384434#M91802 <P>Thank you for response!</P> Mon, 31 Jul 2017 20:36:46 GMT https://communities.sas.com/t5/SAS-Programming/Read-data-from-SQL-server/m-p/384434#M91802 Visiting 2017-07-31T20:36:46Z