Connecting to Common Data Sources

Setting UNIX Environment Variables for SAS/ACCESS

If you are attempting to connect to data sources located on UNIX by using SAS/ACCESS, you must set environmental variables so SAS servers can access the database. Each database vendor and operating system vendor requires specific environment variables to be set. A typical value is LD_LIBRARY_PATH. When using ODBC, two typical values are ODBCINI and ODBCINSTINI. For more information about the correct environment variables, go to the Install Center at http://support.sas.com/documentation/installcenter/92/documents/index.html, and use the operating system and SAS version to locate the appropriate SAS Foundation Configuration Guide.

To set the appropriate environment variables in the !SASROOT/bin/sasenv_local file, perform the following steps:

Edit the sasenv_local file and add the variables. This example uses sample values, substitute the proper paths:

ODBCINI=/opt/Composite_Software/CIS_4.6.0/odbc.ini
export ODBCINI

ODBCINSTINI=/opt/Composite_Software/CIS_4.6.0/odbcinst.ini
export ODBCINSTINI

LD_LIBRARY_PATH=/opt/Composite_Software/CIS_4.6.0/apps/odbc/lib:\
/opt/oracle/app/oracle/product/11.1.0/lib:$LD_LIBRARY_PATH
export LD_LIBRARY_PATH

ORACLE_HOME=/opt/oracle/app/oracle/product/11.1.0
export ORACLE_HOME

In SAS Management Console, right-click the Workspace Server connection and select Validate to verify that the workspace server starts correctly with the new environment variables.
Restart the SAS/SHARE and SAS/CONNECT servers, if they are present in the deployment and reference the SAS/ACCESS library.

Top of Page