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;
If 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.
From Windows Explorer, you can browse to !SASROOT\Access\Sasexe and look for the following files:
1) sasioodb.dll – the presence of this file means that SAS\Access Interface to ODBC is installed on your machine.
2) sasioole.dll – the presence of this file means that SAS\Access Interface to OLEDB is installed on your machine.
Depending 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.
SAS/Access to ODBC:
SQL Server Authentication:
To set up an ODBC Data Source, select the Start Menu, click on Settings