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, 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:
    export ODBCINI
    export ODBCINSTINI
    export LD_LIBRARY_PATH
    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.