Connecting SAS System to TDV ODBC
The SAS system must be installed and functional, for example in the following location:
/opt/sas
For more information, see the installation instructions for the SAS System for Unix.
To configure the connection between the TDV server through ODBC from SAS
1. Make sure that the SAS System is installed and has write access to SAS environment sasenv_local configuration script.
2. Adjust the SAS environment script sasenv_local by adding the necessary environment variables. The script is ltypically ocated at:
/opt/sas/SASFoundation/9.3/bin/sasenv_local
Make sure to set the following environment variables:
Variable | Description |
COMPOSITE_HOME | COMPOSITE_HOME=/usr/local/composite/ export COMPOSITE_HOME |
ODBCHOME | ODBCHOME=/usr/local/unixODBC export ODBCHOME |
ODBCINI | ODBCINI=/usr/local/unixODBC/etc/odbc.ini export ODBCINI |
ODBCINSTINI | ODBCINSTINI=/usr/local/unixODBC/etc/odbcinst.ini export ODBCINSTINI |
3. Test the SAS/Access to ODBC connectivity using the Composite data source by running the following command:
libname comptest odbc datasrc=COMPDEV;
Your results should be similar to:
NOTE: Libref COMPTEST was successfully assigned as follows:
Engine: ODBC
Physical Name: COMPDEV