Understand the Data
Now, let's go back to the four major folders that we have and look at the Documentations folder: The Documentations folder contains the documents about the data files and the requirements to create the SDTM data sets.
Let's click into the Documentations folder. The folder contains:
The lone Excel file contains a description of each of the variables in the CDM data files. For example, one of the data files we have in the CDM folder is the DEATH data file: In the CDM variables file, go to the tab named DEATH.
You will find the descriptions for the variables in the DEATH data set: Now, click into the Specifications folder: You will find the SDTM Excel file: Click the SDTM Excel file to open it, and go to the tabs named DM and DM_DETAILS. For this project, we will create the SDTM DM data set based on these specifications: Now that you have the data and the specifications to create the SDTM data set, let's get started writing some code. |