Adding Target Table Descriptors from a SAS File

This option is available for objects that have target Table Descriptors and support this option: Programs and some Load Sets.

If you specify a single data set file, the system creates a single Table Descriptor. If you specify a SAS transport file that contains more than one data set, the system creates one Table Descriptor for each data set in the file.

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.

Note:

Oracle Life Sciences Data Hub gives SAS variables of SAS format BEST8 a length of 8 and Precision set to null.

1. In the Table Descriptors subtab of the Load Set or Program's Properties screen, click Add Target from SAS File. The system opens the Create Table Descriptors screen with Create a New Table Definition and Descriptor from SAS file selected.
2. Click Browse. The system opens a standard browse screen.
3. Navigate to the location of the SAS file.
4. Highlight the file and click OK, then click Apply

   The system creates a target Table Descriptor and Table definition in the current Work Area. The system returns to the Program or Load Set's Properties screen.

5. Click the Table Descriptor name to see the Table Descriptor screen. You can update the Table Descriptor here as necessary; see Setting Table Descriptor Attributes and Adding or Uploading Columns.
6. Click the Mapping icon for the Table Descriptor and map it to a Table instance. See Mapping Table Descriptors to Table Instances.