Search the site...

SASCRUNCH TRAINING
  • Home
  • Member's Area
  • How to Start
  • SAS Interface
  • Creating a Data Set
  • Practical SAS Training Course
  • SAS Certified Specialist Training Program
  • Proc SQL Course
  • Introduction to Time Series Analysis
  • SAS Project Training Course
  • Full Training / Membership
  • Sign up
  • About us
  • Contact us
  • Home
  • Member's Area
  • How to Start
  • SAS Interface
  • Creating a Data Set
  • Practical SAS Training Course
  • SAS Certified Specialist Training Program
  • Proc SQL Course
  • Introduction to Time Series Analysis
  • SAS Project Training Course
  • Full Training / Membership
  • Sign up
  • About us
  • Contact us
Understand the Data

Now, let's go back to the four major folders that we have and look at the Documentations folder:
Picture
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 Specification folder
  • The TLF Shelfs folder
  • CDM Variables file​
Picture

The lone Excel file contains a description of each of the variables in the CDM data files.
Picture

For example, one of the data files we have in the CDM folder is the DEATH data file:
Picture
In the CDM variables file, go to the tab named DEATH.
 
You will find the descriptions for the variables in the DEATH data set:​
Picture

Now, click into the Specifications folder:
Picture

You will find the SDTM Excel file:
Picture

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:
Picture

Now that you have the data and the specifications to create the SDTM data set, let's get started writing some code.

Next
Already a member? Go to member's area.