1. Installation Guide
  2. Database Tier
  3. Integrate SAS (Optional)
  4. Install SAS on a Windows Computer

Install SAS on a Windows Computer

In this section:

Parent topic: Integrate SAS (Optional)

Modify the opasettings.bat file

To use SAS 9.4 with Oracle Clinical on a Windows platform:

  1. Navigate to the following directory:

    <OPA_HOME>\bin

  2. Open the opa_settings.bat file.
  3. Verify that the value of the SASORA environment variable is commented in opa_settings.bat (is preceded by REM).
    REM set SASORA=V9

Parent topic: Install SAS on a Windows Computer

Install SAS on the Same Windows Computer as Oracle Clinical

Oracle recommends installing SAS on the same Windows server computer as the Oracle Clinical database server installation.

If you choose to install SAS on a Windows server computer different from that of the Oracle Clinical database server installation, you must execute SAS jobs manually. However that configuration is also possible; see Install SAS on a Different Windows Computer from Oracle Clinical.

In this section:

Parent topic: Install SAS on a Windows Computer

Set REMOTE_OS_AUTHENT to FALSE

  1. Verify that the REMOTE_OS_AUTHENT initialization parameter is set to FALSE for the Oracle Clinical database instance in the init.ora file.
    See the table in Install and Configure Oracle Database for more information.

Parent topic: Install SAS on the Same Windows Computer as Oracle Clinical

Set System Path

Ensure that the system path is updated with respect to SAS:

  1. Log in to the Oracle Clinical database server as an administrator.
  2. If the PSUB service is running, stop it.
  3. In the command prompt, enter: path

    The system lists the set of directories in which the system will search for an executable file (in this case, the SAS executable). Among others, the following path must be present (in this example, SAS 9.4 is installed in C:\Program Files):

    C:\Program Files\SAS94\SharedFiles\Formats

    If not present:

    1. Navigate to the Control Panel, then System and Security, then System.
    2. Select the Advanced tab, then Environment Variables.
    3. In the System Variable sections select PATH and click the Edit button.
    4. In the Variable Value box, append the correct value for your location, for example:

      ;C:\Program Files\SAS94\SharedFiles\Formats

      to the existing value and click OK.

    5. Click OK in the Environment Variables dialog box.
    6. Click OK in the System Properties dialog box.
  4. If PSUB should be running, start it.
  5. Log out of the computer.

Parent topic: Install SAS on the Same Windows Computer as Oracle Clinical

Edit the SAS Config File and Grant Permissions

To be able to run SAS on the SAS server of a Windows computer, the user must have full control directory permissions to the following folders located in the SAS software folder:

  • SASWORK
  • SASUSER

To accomplish this:

  1. Log in to the Oracle Clinical database server as an administrator.
  2. Using Windows Explorer, navigate to the location where you have installed SAS 9.4. In the following example, SAS 9.4 is installed in C:\Program Files:

    C:\Program Files\SAS94\SASFoundation\9.4\nls\en

  3. Open SASV9.cfg file in a text editor.
  4. Comment the existing lines about -SASUSER and -WORK and add new ones, substituting any directory you choose for D:\sasuser and D:\sastemp, so that the section looks like this:
    /* Setup the default SAS System user profile folder    */ 
/*-SASUSER "?CSIDL_PERSONAL\My SAS Files\9.2"*/ 
-SASUSER "D:\sasuser" 

/* Setup the default SAS System user work folder       */ 
/*-WORK "!TEMP\SAS Temporary Files"*/ 
-WORK "D:\sastemp"
  5. Save the file.
  6. Create directories D:\sasuser and D:\sastemp or your preferred equivalents. (In Windows Explorer, right-click and then select New, then Folder.)
  7. Give full control directory permissions on these directories to the oclsascr group.

Parent topic: Install SAS on the Same Windows Computer as Oracle Clinical

Install SAS on a Different Windows Computer from Oracle Clinical

You can also install SAS on a computer other than the Oracle Clinical database. However, if you do you must execute SAS jobs manually after their generation from Oracle Clinical. See the Data Extract chapter in the Oracle Clinical Conducting a Study manual for more information.

In this section:

Parent topic: Install SAS on a Windows Computer

Set REMOTE_OS_AUTHENT to FALSE

To set REMOTE_OS_AUTHENT to FALSE:

  1. Verify that the REMOTE_OS_AUTHENT initialization parameter is set to FALSE for the Oracle Clinical database instance in the init.ora file.
    See the table in Install and Configure Oracle Database for more information.

Parent topic: Install SAS on a Different Windows Computer from Oracle Clinical

Edit the SAS Config File and Grant Permissions

To be able to run SAS on the SAS server of a Windows computer, the user must have full control directory permissions to the following folders located in the SAS software folder:

  • SASWORK
  • SASUSER

To accomplish this:

  1. Log in to the server as Administrator.
  2. Using Windows Explorer, navigate to the location where you have installed SAS 9.4. In the following example, SAS 9.4 is installed in C:\Program Files:
    C:\Program Files\SAS94\SASFoundation\9.4\nls\en
  3. Open SASV9.cfg file in a text editor.
  4. Comment the existing lines about -SASUSER and -WORK and add new ones, substituting any directory you choose for D:\sasuser and D:\sastemp, so that the section looks like this:
    /* Setup the default SAS System user profile folder    */ 
/*-SASUSER "?CSIDL_PERSONAL\My SAS Files\9.3"*/ 
-SASUSER "D:\sasuser" 

/* Setup the default SAS System user work folder       */ 
/*-WORK "!TEMP\SAS Temporary Files"*/ 
-WORK "D:\sastemp"
  5. Save the file.
  6. Create directories D:\sasuser and D:\sastemp or your preferred equivalents. (In Windows Explorer, right-click and then select New, then Folder.)
  7. Give full control directory permissions on these directories to the oclsascr group.

Parent topic: Install SAS on a Different Windows Computer from Oracle Clinical

Set Values in OCL_STATE Reference Codelist

  1. Set the following values in the Oracle Clinical OCL_STATE reference codelist:
    • REMOTE_SASOUT
    • REMOTE_SAS_SERV
    • REMOTE_SAS_VIEW

Parent topic: Install SAS on a Different Windows Computer from Oracle Clinical