Creating an Oracle Life Sciences Data Hub Table From a SAS Data Set

You can upload SAS data set metadata into Oracle LSH to create a Table with the same structure as a data set in an integrated external system. The system creates Table Columns with the same data type and length as the variables in the data set.

Note:

Oracle LSH gives SAS variables of SAS format BEST8 a length of 8 and Precision set to null.

The system searches for Variables in the same Application Area with the same name, data type, and length as each of the variables in the data set. If a matching Variable exists, the system bases a Column of the Table definition on it. If a Table definition with the same name already exists in the Application Area, the system appends _1 to it, or _x if the Table name already has a number appended, where x is the next larger integer.

Figure 4-2 Process for creating a SAS Data Set

Description of "Figure 4-2 Process for creating a SAS Data Set"

When you select Create new table definition and instance from SAS data set in the Create Program screen, additional fields appear.

1. Click Browse. A standard Choose file pop-up window opens.
2. Select the .sas file on a local or shared drive and click Open.
3. In the Classification section, select the following for both the definition and the instance:
   • Subtype. Select a subtype according to your company's policies.
   • Classification Values. See Classifying Objects and Outputs for instructions.
4. Click Apply to save your work and continue defining the Table.

   The system opens the Properties screen for the new Table instance.

5. Define the Table details in the lower part of the screen. See:
   • Defining Table Columns
   • Defining Table Constraints and Indexes

Note:

You can also create an Oracle LSH Table from a SAS data set when you define Load Set Table Descriptors. You can then use the Actions drop-down list item Table Instance from Existing Table Descriptor to create an identical target Table instance and map the two.