Loading External Views

To load external views, your files must have SQL text specifications for queries or views so that the data extract view text for both the Oracle and SAS view is created.

To reach the PSUB form you need for loading, from the Conduct menu, select Data Extract, then select Load External View.

1. Enter the study, view name, and name of the file to load.
   The file names containing the Oracle and the SAS text must have the same name and the file extensions .SQL and .SAS, respectively. Enter the file name of the .SQL file in the submission window. The module determines the .SAS file name from the .SQL file name.
2. Click the Submit Job button.

The batch job loads the text of the SQL and SAS views into the Data Extract Views table. When the job has completed, continue data extract view maintenance for the view(s) you want to create, which are created in the study access accounts selected.