What's the project goal?
The goal of the project is to create the SDTM DM data set based on the SDTM specification file (i.e. dm_only.xlsx).
Based on the specification file, we have to create 29 variables for the STDM DM data set:
Let's look at the first three variables:
Creating these three variables is quite straightforward.
The STUDYID and DOMAIN column should just be assigned the values 'XYZ' and 'DM', respectively.
The USERID is just to concatenate the STUDYID and SUBJECT, separated by a slash.
Below is the code to create these three variables:
STUDYID = 'XYZ';
DOMAIN = 'DM';
USERID = catx('/', STUDYID, SUBJECT);
keep studyid domain userid;
The remaining columns aren't as simple as the first three.
You can complete the remaining variables based on the specification file!