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 that 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/93, 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:
  1. 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
  2. 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.
  3. Restart the SAS/SHARE and SAS/CONNECT servers, if they are present in the deployment and reference the SAS/ACCESS library.