Creating a SAS Format Catalog

To create a SAS Format Catalog in Oracle Life Sciences Data Hub:

1. Create an Oracle LSH Program of type SAS Format Catalog. Give it a name and description that describe its purpose.

   Note:

   You cannot set a Static Reference Source Code as primary. Also, you cannot set a Source Code that points directly to a Program definition as primary.

2. If any of the formats in the Catalog are table-dependent, add the necessary Table Descriptor(s) using the Oracle LSH Table definition that you created for formats as the source Table definition (see Creating a Table Descriptor).
3. Map any Table Descriptors to Table instances (see Mapping Table Descriptors to Table Instances).
4. Add a Source Code definition of type Program that contains the format source code (see Creating Source Code).

   If the format is Table-dependent, the source code must use the Table Descriptor as input and include a SAS Proc format to create the format catalog in SAS.

   You can also add Source Codes of type Macro to support the format building steps if necessary.

5. Set the Source Code's Sharable flag to Yes.

   Note:

   You cannot set any Source Code instance that points directly to a Program definition as Sharable.
6. Repeat as necessary; you can have multiple format Source Codes in a single Oracle LSH SAS Format Catalog.
7. Apply. The system saves the Source Code definition(s) and instances in the database and returns you to the Program's main page.
8. Install the Program in the database (see Running a Work Area Installation).