Creating SAS Views on Windows when SAS and Oracle Clinical are on Different Computers

Oracle recommends installing SAS on the same computer where your Oracle Clinical database is installed. It is also possible to install them on different computers, but in that case running the Data Extract Views PSUB job only creates the SAS pass-through view files on the SAS server —it does not automatically launch the batch job to create the actual views. You must manually launch the SAS View Creation batch job as follows:

1. Log on to the SAS server using your local account.
2. Copy the files from database server's %RXC_SAS_VIEW% directory for a study into the corresponding directory on the SAS server.
3. On the SAS server, change directory to %RXC_SAS_VIEW%.
4. Change directories to study where study is the name of the study for which you are generating views. Change directories to study_access_account where study_access_account is the name of the account for which you are generating views; for example, current, test or the user-defined name of a snapshot.
5. Set the server environment:

   set p1=db_name

   set p2=code_env

   opa_setup

   Where db_name is a database instance name and code_env is a code environment designation.

6. Edit rxcdxbvb_sasjob.bat by updating the log file path to the path that exists on the SAS server.
7. Run the SAS view generation script:
   rxcdxbvb_sasjob.bat

The script creates a SAS pass-through view for each data extract view defined for the study and account.