Read data from SQL server

[Visiting]

How can I directly import data from SQL server to SAS? Is there sample code? Thank you!

[Reeza]

First you need to connect to SQL and that depends on your system set up. 

[Visiting]

Thank you for response!

[kiranv_ · Accepted solution]

you can do this by defining libname as shown below or by doing explicit pass through

LIBNAME SQL ODBC DSN=’sql server’ user=sasjlb pw=pwd;

Below two papers will be to give lot of info on this

https://support.sas.com/techsup/technote/ts765.pdf

http://analytics.ncsu.edu/sesug/2002/DM10.pdf

[Visiting]

Thank you!