Validating a Define.xml File :: SAS(R) Clinical Data Integration 2.6: User's Guide

Overview: Validating a Define.xml File

The CDISC-Define Validation transformation assesses the validity of the define.xml file. Validity is based on the XML standards 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 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 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, see Register a New Document File.

Validate a Define.xml File

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

Create an empty job.

For detailed information about creating an 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 and drop CDISC-Define Validation onto the diagram.
From the Folders tree, drag and drop 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 the Results work table permanently, perform the following steps:

Note: By default, the 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) In the diagram, double-click CDISC-Define Validation.

The CDISC-Define Validation Properties dialog box appears.
1. Click the Validation tab, and select a define version to use for the validation.
2. Click the Reports tab, and perform the following steps:
  
  Select the Generate Report check box.
  
  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.
  
  Enter a name for the report in the Report File Name field, and then specify the report output format.
  
  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.
  
  Select the panels to include in the report and whether informational messages are included.
3. Click OK to close the CDISC-Define Validation Properties dialog box.
Click Run.

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

If there are errors in the define.xml file, the 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.