My apologies for the extremely long delay in replying and marking a solution. I appreciate all the replies to my question and the document that was provided was very helpful. And one additional apology for thinking this was the sub-community for just my company and not the entire SAS community (again, very new to SAS/community and that's the reason my acronyms wouldn't have made much sense; just for clarification, ODW is a SQL Server database). There was just one additional tweak I'll mention that I needed to make for the connection to be successful... I used this syntax in my proc sql statement: proc sql; connect to SQLSVR as myODWtestCon(DSN=ODW user=XXXXXXX password=XXXXXXXX); When I first tried "ODBC" (in place of SQLSVR), the connection would fail, but was successful with SQLSVR. Thanks again to all that replied. Stuart
... View more