https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/How-to-read-tables-from-MS-SQL-Server-to-SAS/m-p/1658#M96 Here's an example from Tech Support:<BR /> <A href="http://support.sas.com/ctx/samples/index.jsp?sid=1529&amp;tab=code" target="_blank">http://support.sas.com/ctx/samples/index.jsp?sid=1529&amp;tab=code</A><BR /> cynthia Thu, 26 Oct 2006 22:25:10 GMT Cynthia_sas 2006-10-26T22:25:10Z https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/How-to-read-tables-from-MS-SQL-Server-to-SAS/m-p/1657#M95 Hi there,<BR /> <BR /> 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. Thu, 26 Oct 2006 15:40:27 GMT https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/How-to-read-tables-from-MS-SQL-Server-to-SAS/m-p/1657#M95 deleted_user 2006-10-26T15:40:27Z https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/How-to-read-tables-from-MS-SQL-Server-to-SAS/m-p/1658#M96 Here's an example from Tech Support:<BR /> <A href="http://support.sas.com/ctx/samples/index.jsp?sid=1529&amp;tab=code" target="_blank">http://support.sas.com/ctx/samples/index.jsp?sid=1529&amp;tab=code</A><BR /> cynthia Thu, 26 Oct 2006 22:25:10 GMT https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/How-to-read-tables-from-MS-SQL-Server-to-SAS/m-p/1658#M96 Cynthia_sas 2006-10-26T22:25:10Z https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/How-to-read-tables-from-MS-SQL-Server-to-SAS/m-p/1659#M97 Thanks! Mon, 30 Oct 2006 21:02:30 GMT https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/How-to-read-tables-from-MS-SQL-Server-to-SAS/m-p/1659#M97 deleted_user 2006-10-30T21:02:30Z