Importing Data Standards Metadata

Overview

You define a study relative to a particular data standard, such as CDISC-SDTM or a data standard from your company, by importing the data standard from the SAS Clinical Standards Toolkit.
If you want to use a CDISC standard, import data standard metadata from the SAS Clinical Standards Toolkit. Importing the metadata enables you to update your environment with new releases of data standards from CDISC. CDISC data standards are provided with the SAS Clinical Standards Toolkit. For more information, see the SAS Clinical Standards Toolkit: User's Guide.
After importing a data standard that supports domain templates, column groups, and validation data sets, these items are displayed in the Data Standards folder in the Clinical Administration tree. For example, if you select the CDISC-SDTM data standard type and version 3.1.2, the domain templates (SDTM domains), column groups (SDTM classes), and validation data sets (compliance checks) are displayed in a folder that you specify in the Import wizard.
By default, an imported data standard has a status of Inactive. This status enables you or a data standards administrator to review the template and make changes before releasing it for general use. When you or the data standards administrator is satisfied with the template, you can change its status to Active, which makes the template available for general use. For more information, see Make a Data Standard Available for General Use.
Note: You must have appropriate permissions to view the Clinical Administration tree. For more information, see Adding Users to the Clinical Administrators Group.

Import Data Standards Metadata

To import data standards metadata, perform the following steps:
  1. In the Clinical Administration tree, select Data Standards, right-click, and then select Import.
    The Import Wizard appears.
    Import wizard
  2. Select the metadata source, and then click Next.
  3. If the Default Application Server page appears, select one of the application servers that are listed.
    The Default Application Server page appears only when the Import Wizard is used for the first time. If you are unsure about which application server to select, contact the SAS installation representative.
  4. On the Select Data Standard Type page, select the data standard type, and then click Next.
    The Select Data Standard Version page appears.
  5. Select the data standard version to use, and then click Next.
    The CDISC standards that are listed are in the form of the standard short name, followed by the standard version number. For example, for SDTM 3.1.2, SDTM is the standard short name, and 3.1.2 is the standard version number). Each standard listing might also include a revision number that indicates the SAS Clinical Standards Toolkit version from which the standard definition was taken (for example, SDTM 3.1.2 (Revision 1.4).
  6. On the Define General Properties page, edit the default values.
    1. Enter the name and the optional description.
      Note: It is a best practice not to include spaces in the data standard name.
    2. (Optional) In the Formal Name field, enter a more descriptive name for the data standard.
    3. In the Identifier field, enter a text value to uniquely identify the data standard in metadata.
      A default value is provided. The value that you enter is verified as unique before you continue.
    4. Select a type.
      The values in the list are set up by the SAS Clinical Data Integration system administrator. These values are important when using the data standards metadata in the SAS Clinical Standards Toolkit. If the required type is not in the list, you should contact the system administrator to add the type, especially if the data standard uses the SAS Clinical Standards Toolkit. For more information about adding types, see Customizing Data Standard Properties.
      If the data standard does not use the SAS Clinical Standards Toolkit, you can select any value.
    5. (Optional) Enter the version and vendor, and then click Next.
      The Verify Domain Properties page appears.
  7. (Optional) Edit the domain property values, and then click Next.
    Note: Domain properties are an advanced feature in SAS Clinical Data Integration. If you are uncertain about what domain property values to select, accept all of the default values.
    The Verify Domain Column Properties page appears.
  8. (Optional) Edit the domain column property values, and then click Next.
  9. (Optional) If the data standard supports validation, on the Validation Library page, select a library or create a library, and then click Next..
    For more information about SAS libraries, see the SAS Data Integration Studio: User's Guide or the SAS Data Integration Studio online Help.
    Note:
    • You must have appropriate permissions for the selected library. For more information about permissions, see SAS Management Console: Guide to Users and Permissions.
    • The path for the selected library must exist.
    • The library metadata object is created immediately. Even if you close the Import Model wizard, the library will remain.
  10. (Optional) If the data standard supports a data model, on the Verify Column Groups page, perform the following steps:
    1. Review the column groups that are defined in the data standard, and then click Next.
      The Verify Column Groups page is refreshed with detailed information about the columns that are defined in the data standard.
    2. Click Next again.
  11. (Optional) On the Verify Domain Metadata page, review the domain templates that are defined in the data standard, and then click Next.
    Note: This information is provided only as a reference. It enables you to review the metadata before storing it. You cannot make changes to this information. If you see problems in the metadata, contact whomever is responsible for registering the data standard in the SAS Clinical Standards Toolkit.
  12. (Optional) On the Verify Domain Column Metadata page, review the columns that are defined in the data standard, and then click Next.
    Note: This information is provided only as a reference. It enables you to review the metadata before storing it. You cannot make changes to this information. If you see problems in the metadata, then contact whomever is responsible for registering the data standard in the SAS Clinical Standards Toolkit.
  13. Review the summary, and then click Finish.

Make a Data Standard Available for General Use

To make a data standard available for general use, perform the following steps:
  1. In the Clinical Administration tree, expand Data Standards.
  2. Select the data standard, right-click, and then select Properties.
    The Data Standard Properties dialog box appears.
    Data Standard Properties dialog box
  3. Click the Properties tab.
    Data Standard Properties dialog box — Properties tab
  4. In the Active row, change false to true.
  5. Click OK.