Validating a CRT-DDS define.xml File :: SAS(R) Clinical Data Integration 2.4: User's Guide

Overview: Validating a CRT-DDS define.xml File

The Validate CRT-DDS transformation assesses the validity of the define.xml file. Validity is based on the XML standards for CRT-DDS 1.0.0 as defined by CDISC.

Validity is based on the following criteria:

The XML is well formed.
The XML meets the XML schema specification for the CDISC CRT-DDS 1.0 standard.

Note: For detailed information about creating a job with a transformation, see the SAS Data Integration Studio: User's Guide or the SAS Data Integration Studio online Help.

Register a New Document File

Before you can create a job to validate a CRT-DDS define.xml file, you must register a new document file. The new document file must point to an existing define.xml file in a location that the SAS Workspace Server can access.

For more information about registering a new document file, seethe SAS Data Integration Studio: User's Guide or the SAS Data Integration Studio online Help.

Validate a CRT-DDS define.xml File

To validate a CRT-DDS define.xml file, perform the following steps:

Create an empty job.

For detailed information about creating a empty job, see the SAS Data Integration Studio: User's Guide or the SAS Data Integration Studio online Help.
In the Transformations tree, expand Clinical, and then drag Validate CRT-DDS onto the diagram.
From the Folders tree, drag the define.xml file onto the diagram.
Drag the cursor from the define.xml file to the input port of the transformation.

This action connects the define.xml file to the transformation.
To store CRT-DDS Validation Results work table permanently, perform the following steps:

Note: By default, the CRT-DDS Validation Results work table is written to a temporary work location.
1. Right-click the Work Table icon , and then select Properties.
  
  The Properties dialog box appears.
  
  For detailed information about the Properties dialog box, see the SAS Data Integration Studio: User's Guide or the SAS Data Integration Studio online Help.
2. Click the Physical Storage tab, select a SAS library for the Location field.
(Optional) Click the Reports tab, and perform the following steps:
1. Select the Generate Report check box.
2. Perform one of the following steps:
  
  Click Browse adjacent to Browse to Folder, and then navigate to a server folder.
  
  In the Server Folder field, enter the name of a server folder.
  
  The folder must be on the server and must not be a local folder.
3. Enter a name for the report in the Report File Name field, and then specify the report output format.
4. To limit the number of records to include in the report, enter a number in the Limit # of records to field.
  
  If you leave this field blank, all records are included in the report.
5. Select the panels to include in the report and whether informational messages are included.
Click OK to close the Validate CRT-DDS Properties dialog box.
Click Run.

SAS Data Integration Studio generates the SAS code for validating, and then submits the code to SAS. The CRT-DDS define.xml file is validated, and then the results are written to the CRT-DDS Validation Results work table.

If there are errors in the CRT-DDS define.xml file, the CRT-DDS Validation Results work table provides a message for each error. An error message includes the line and column number in the define.xml file that generated the error.