Dive into CDISC Express (1): Introductory
Dive into CDISC Express (2): Create a New Study
A more friendly PDF version of these all CDISC Express series is also available in
The following tasks, such as generating SDTM domains and define.xml, need just some clicking button work in CDISC Express using a well designed mapping file. Few words needed due to the software.
5. Step 3 of 6: Validate mapping file (Validate_Mapping_File.sas)
It would be back and forth to design, validate then modify and re-validate the mapping file. And sure finally, you will get all the work done, at least no syntax error (how to avoid semantic errors is upon your domain knowledge). A validated mapping file, named mapping.xls will be copied to … docMapping file – validated version from the working file, tmpmaping.xls. You will see
The corresponding log file in folder … log
A report in …resultsMapping Validation, named Mapping_validation.html
Also the temporary datasets in …tempdata and …temp:
6. Step 4 of 6: Generate SDTM datasets (_generateSDTM.sas)
If mapping file is OK, generating SDTM domains is just clicking the button. After submitting the codes, you will see the log file, reports, SDTM datasets and temporary datasets in corresponding folders:
7. Step 5 of 6: Validate SDTM datasets (Validate_SDTM_Domains.sas)
The outputs files of validating SDTM datasets are all located in C:Program FilesCDISC ExpressSDTM Validation:
8. Step 6 of 6: Generate Define.xml and xpt (_generateDefinexml.sas)
Get the final define.xml file and SAS transport files (.xpt):
9. Recommended reading and action taken
For a quick start and deep understanding, you could read the official documentations in the following sequence:
C:Program FilesCDISC ExpressdocumentationFAQ.htm
C:Program FilesCDISC ExpressdocumentationQuick Start.htm
C:Program FilesCDISC ExpressdocumentationUser guide.htm
A video tutorial would be also helpful:
C:Program FilesCDISC Expressdocumentationvideotutorial.htm
A must-read conference paper, An Excel Framework to Convert Clinical Data to CDISC SDTM Leveraging SAS Technology by Sophie McCallum and Stephen Chan of Clinovo, supplies a wonderful discussion the architectures of CDISC Express:
http://www.lexjansen.com/pharmasug/2011/ad/pharmasug-2011-ad08.pdf
Of course, you do not need to review all the pages then get the confidence to use the software. Learn by doing and just dive into it. There is an opportunity for your practicing and you will also have a change to win an iPad2 from Clinovo’s CDISC Express Contest:
The due day is July 15th and I already submitted my work. That’s fun.