SAS LA Forum Coders' Corner
From sasCommunity
Archived SAS LA Forum Coders' Corner
2010
Getting SAS® to Play Nice With Others: Connecting SAS® to Microsoft SQL Server Using an ODBC Connection (Click here for SAS Global Forum 2008 Paper)
Candice Miller, RAND Corporation
Getting SAS to interact with other databases is often vital to the success of a project, but this can be a problem when SAS and the databases being used are on different platforms. This paper discusses connecting SAS to a Microsoft SQL Server from both PC and Linux environments using SAS/ACCESS and the odbc engine. The paper also discusses the role the Libname Statement and the Pass Through Facility play in this connection. Proc SQL, macro variables, and some basic SQL settings and syntax will be discussed to demonstrate the power of this connection. Finally, UnixODBC and FreeTDS are discussed as third-party tools in getting the Linux environment set up.
