Want to win an Ipad2? Download CDISC Express and simply create your own CDISC mapping file!
Your challenge is to create a mapping file to map the source data set provided on this page to the SDTM DM domain using CDISC Express. Learn more about CDISC Express.
Follow the different steps and rules and send us your mapping file and SAS macro before July 15th. The winner will be selected at random among the correct mapping files and SAS macros.
4 steps to participate:
- Download CDISC Express
- Download the source data sets
- Create the mapping file following the rules below
- Upload your mapping file and your SAS macro on www.clinovo.com/cdisccontest
THE RULES
For the study CLINCAP, create the mapping file for the domain DM for the REQUIRED and EXPECTED variables only. Fourteen variables need to be mapped according to the following conventions:
- STUDYID: Name of the study
- DOMAIN: Name of the domain. Use a macro variable in the expression
- USUBJID: Concatenation of study ID, site ID and patient ID
- SUBJID: Patient ID
- RFSTDTC: Treatment date for the ‘visit 1’ from the source data set TREATMENT. Tip: Look at the function library
- RFENDTC: Treatment date for the ‘visit 4’ from the source data set TREATMENT
- SITEID: Site ID
- AGE: Use the following expression to calculate the age: year(consentdt)-year(birthdt)-(month(birthdt)>month(consentdt))-(month(birthdt)=month(consentdt) and day(birthdt)>day(consentdt)) Tip: Note that consentdt comes from the source data set ARM and birthdt comes from the source data set DEMOGRAPHICS
- AGEU: use the constant “YEARS”
- SEX: This variable should take the value M or F. In the source dataset DEMOGRAPHICS, sex is a numeric variable with the value 1 for male and 2 for female
- RACE: Create your own macro in the function library to map this variable. In the source dataset DEMOGRAPHICS, if white=’Y’ then RACE should be equal to WHITE. If asian=’Y’ then RACE should be equal to ASIAN
- ARMCD: Treatment group code from the source data set ARM
- ARM: Treatment group from the source data set ARMDESCRI. Tip: Use a merge
- COUNTRY: Country from the data set SITE. Note the structure of the table. Some lines need to be excluded. Also this variable need to be uppercase in the DM domain
- Height: From demographics data set. Variable label should be ‘Height baseline’ and origin ‘CRF’
Two data sets are created: DM and SUPPDM
All the mapping is done using the mapping file (merge, format, macro calls…)
Only one macro needs to be developed for the RACE variable
The source data set cannot be modified
The tabs STUDYMETADATA from the mapping file is not used in this challenge
The mapping you created should generate the following data sets:
DM data set :
SUPPDM data set :
