On Microsoft Windows, you have two options to access a Microsoft SQL Server database from SAS. You can use either SAS\/Access Interface to ODBC, or SAS\/Access to OLEDB.
\nSubmitting the following code from within SAS displays all the licensed products for your site in the SAS log window:
\nProc setinit noalias;
\nRun;
\nIf you have one or both of the Access products licensed for your site, the next step is to determine if the products have been installed on your machine.
\nFrom Windows Explorer, you can browse to !SASROOT\\Access\\Sasexe and look for the following files:
\n1) sasioodb.dll \u2013 the presence of this file means that SAS\\Access Interface to ODBC is installed on your machine.
\n2) sasioole.dll – the presence of this file means that SAS\\Access Interface to OLEDB is installed on your machine.
\nDepending on how SQL Server is set up, you can connect using either SQL Server Authentication or NT Authentication. Using SAS\/Access to ODBC or SAS\/Access to OLEDB with each authentication method will be discussed below.
\nSAS\/Access to ODBC:
\nSQL Server Authentication:
\nTo set up an ODBC Data Source, select the Start Menu, click on Settings <\/p>\n","protected":false},"excerpt":{"rendered":"
On Microsoft Windows, you have two options to access a Microsoft SQL Server database from SAS. You can use either SAS\/Access Interface to ODBC, or SAS\/Access to OLEDB. Submitting the following code from within SAS displays all the licensed products for your site in the SAS log window: Proc setinit noalias; Run;<\/p>\n