Validating a CRT-DDS define.xml File

Problem

You want to validate a CRT-DDS define.xml file to ensure that it complies with the CRT-DDS data standard and that it meets XML standards.

Solution

Use the Validate CRT-DDS transformation to assess 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:

XML is well formed
XML meets the XML schema specification

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

Tasks

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, see the SAS Data Integration Studio: User's Guide.

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

In SAS Data Integration Studio, create a new job. Select FileNewJob. An empty job diagram is displayed on the Diagram page.
In the Transformations tree, expand Clinical, select Validate CRT-DDS, and drag and drop it onto the diagram. The Diagram page displays the CRT-DDS transformation.
In the Folders tree, drag and drop the define.xml file onto the diagram.
Connect the define.xml file to the Validate CRT-DDS transformation. 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.
By default, the CRT-DDS Validation Results data set is written to a temporary work location. If you want to store this information permanently, right-click on the Results data set , and select Properties. Change the location on the Physical Storage tab. For detailed information about the properties dialog box, see the SAS Data Integration Studio: User's Guide.
Click Run to run the job. 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 the results are written to the CRT-DDS Validation Results data set.

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