Running the CDISC-SDTM to CRT-DDS Transformation on Saved Data

Overview

The CDISC-SDTM to CRT-DDS transformation operates on saved data so that the information that is stored in the data is added to the CRT-DDS standard.

You create and run a job with a transformation that creates a CRT-DDS define.xml file. The file includes SAS data sets that represent the CRT-DDS data standard model.

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.

Here is example code that creates a define.xml file:

%let SASCrtddsTables = %nrquote(\\myCDIServer\mydata\crtdds_tables);
%let DefPath = %nrquote(\\myCDIServer\mydata\crtdds_tables);
%let DefFile = %nrquote(define.xml);

%cst_setStandardProperties(
  _cstStandard=CDISC-CRTDDS
  ,_cstSubType=initialize
  ); 
%let workPath=%sysfunc(pathname(work));
%let _cstSASRefs=work.sasreferences;
%let _cstSASRefsLoc=&workpath;
%let _cstSASRefsName=sasreferences;
%let _cstResultsds=crtdds_results;
%cst_createds(_cstStandard=CST-FRAMEWORK, _cstType=control,
_cstSubType=reference, _cstOutputDS=work.sasreferences);
proc sql;
insert into work.sasreferences 
values ( "CST-FRAMEWORK"  "1.2"  "messages"  ""  "messages"  "libref"  "" 1  ""  "" ) 
values ( "CDISC-CRTDDS"  "1.0"  "messages"  ""  "crtmsg"  "libref"  "" 2  ""  "" ) 
values ( "CDISC-CRTDDS"  "1.0"  "autocall"  ""  "auto2"  "fileref"  "" 1  ""  "" ) 
values ("CDISC-CRTDDS" "1.0" "sourcedata"  ""  "srcdata"  "libref"  
    "&SASCrtddsTables" . ""  "" )
values ("CDISC-CRTDDS" "1.0" "externalxml"  "xml"  "extxml"  "fileref"  
    "&defpath" 1 "&deffile"  "" )
values ("CDISC-CRTDDS" "1.0" "referencexml"  "stylesheet"  "xslt01"  
    "fileref"  "" 1 ""  "" )
;
quit;

%cst_insertStandardSASRefs(_cstSASReferences=sasreferences,
    _cstOutputDS=sasreferences);
%let _cstReallocateSasrefs=1;
%cstutil_allocatesasreferences;
%crtdds_write(_cstCreateDisplayStyleSheet=1,_cstResultsOverrideDS=&_cstResultsDS);

In the example code, edit SASCrtddsTables to specify the location where the saved data sets exist, and edit DefPath to specify the location to write the resulting define.xml file.

Note: If you are viewing an electronic version of this document, you can cut and paste the example code.

Run the CDISC-SDTM to CRT-DDS Transformation

To run the CDISC-SDTM to CRT-DDS transformation, perform the following steps:

Select FileNewJob.

An empty job diagram appears on the Diagram page.
In the Transformations tree, expand Data, and then drag User Written Code transformation onto the diagram.
Right-click User Written, and then select Properties.

The User Written Properties dialog box appears.
Click the Code tab.
From the Code generation mode drop-down list, select All user written.
In the code editor, enter the code to create the define.xml file.

For example code, see Overview.
Click OK and then click Run.
From the Windows Start menu, select Run, and then enter the location where the data sets are located (for example, \\myCDIServer\mydata\crtdds_tables).
Open the define.xml file.

The Location field contains a link to the corresponding transport file. If you click on the link, and the transport file does not exist, you get an error. Search the file for Blank Annotated CRF (blankCRF.pdf#page=3). The define file has valuelist values for height and weight.