How to read tables from MS SQL Server to SAS?

[deleted_user]

Hi there,

I need to read a MS SQL database (ODBC connection on Windows) to my local SAS dataset on Windows. I have installed SAS/Access to ODBC interface on my desktop. Could anybody let me know how to do this? Thanks for the help.

[Cynthia_sas]

Here's an example from Tech Support:
http://support.sas.com/ctx/samples/index.jsp?sid=1529&tab=code
cynthia

[deleted_user]

Thanks!