Clinical Data Management


Why this course ?

  • This Hands-On course on Clinical Data Management and SAS Program is developed to provide candidates with a skillful knowledge of the management of clinical data
  • The course cover everything from manipulating data to writing SAS programs
  • This Course will help to prepare you for the Base SAS Programming certification exam.
  • This course cover Processing SAS data using Structured Query Language (SQL).

Program Duration
and Fees


65 Hours




1.1 An Overview of the SAS System
Getting Started With the SAS® System
2.1 Introduction to SAS Programs
2.2 Running SAS Programs
2.3 Mastering Fundamental Concepts
2.4 Diagnosing and Correcting Syntax Errors
2.5 Exploring Your SAS Environment
Getting familiar with SAS Data Sets
3.1 SAS Data Libraries
Producing List Report
4.1 Getting Started With the PRINT Procedure
4.2 Sequencing and Grouping Observations
4.3 Identifying Observations
4.4 Special WHERE Statement Operators

Enhancing Output
5.1 Customizing Report Appearance
5.2 formatting Data Values
5.3 Creating HTML Reports
Creating SAS® Data Sets
6.1 Reading Raw Data Files: Column Input
6.2 Reading Raw Data Files: Formatted Input
6.3 Examining Data Errors

6.4 Assigning Variable Attributes
6.5 Changing Variable Attributes
6.6 Reading Excel Spreadsheets
DATA Step Programming
7.1 Reading SAS Data Sets and Creating Variables
7.2 Conditional Processing
7.3 Dropping and Keeping Variables
7.4 Reading Excel Spreadsheets Containing Date Fields

Combining SAS Data Sets
8.1 Concatenating SAS Data Sets
8.2 Merging SAS Data Sets
8.3 Combining SAS Data Sets : Additional Features
Producing Summary Reports
9.1 Introduction of Summary Reports.
9.2 Basic Summary Reports
9.3 The Report Procedure
9.4 The Tabulate Procedure
Introduction to Graphics
10.1 Producing Bar and pie Chart
10.2 Enhancing output
10.3 Producing Plots
SAS Programing II


1.1 Overview
1.2 Review of SAS basics
1.3 Review of DATA Step Processing
1.4 Review of Displaying SAS Data Sets
1.5 Working with Existing SAS Data Sets

Controlling Input and Output
2.1 Outputting Multiple Observations
2.2 Writing to Multiple SAS Data Sets
2.3 Selecting Variables and Observations
2.4 Writing to an External File

Summarizing Data
3.1 Creating an Accumulating Total variable
3.2 Accumulating Totals for a Group of Data

Reading & Writing Different Types of Data
4.1 Reading Delimited Raw Data Files
4.2 Controlling When a Record Loads
4.3 Reading Hierarchical Raw data Files
Data Transformations
5.1 Introduction
5.2 Manipulating Character values
5.3 Manipulating Numeric values
5.4 Manipulating Numeric values based on Dates
5.5 Converting variable Type

Debugging Techniques
6.1 Using the PUT Statement
6.2 Using the DEBUG Option

Processing Data Iteratively
7.1 Do Loop Processing
7.2 SAS Array Processing
7.3 Using SAS Arrays

Combining SAS® Data Sets
8.1 Match-merging Two or more SAS Data Sets
8.2 Simple Joins Using the SQL Procedure
Introduction to the SQL Procedure
o What is SQL?
o What is the SQL Procedure?
o Terminology
o Comparing PROC SQL with the SAS DATA step
o Note about the Example Table

Retrieving Data From a Single Table
o Overview of the select Statement
o Selecting Columns in a Table
o Creating New Columns
o Sorting Data
o Retrieving rows that satisfy a Condition
o Summarizing Data
o Grouping Data
o Filtering Grouped Data

Retrieving Data from Multiple Tables
o Introduction
o Selecting Data from More Than One Table by Using joins
o Using Subqueries to Select Data
o When to Use Joins and Subqueries
o Combining Queries with Set Operators

Creating and Updating Tables and Views
o Introduction
o Creating Tables
o Inserting Rows into Tables
o Updating Data Values in a Table
o Deleting Rows
o Altering Columns
o Creating an Index
o Deleting a Table
o Using SQL Procedure Tables in SAS Software
o Creating and Using Integrity Constraints in a Table
Programming with the SQL Procedure
o Introduction
o Using Proc SQL Options to Create and Debug Quires
o Improving Query Performance
o Accessing SAS System Information Using DICTIONRY Tables
o Using Proc SQL with the SAS Macro Facility
o Formatting PROC SQL output Using the Report Procedure
o Accessing a DBMS with SAS/ACCESS Software

Practical Problem-Solving with PROC SQL
o Overview
o Computing a Weighted Average
o Comparing Tables
o Overlaying Missing Data Values
o Computing Percentages within Subtotals
o Counting Duplicate Rows in a Table
o Expanding Hierarchical Data in a Table
o Summarizing Data in Multiple Columns
o Creating a Summary Report
o Creating a Customized Sort Order
o Conditionally Updating a Table
o Updating a Table with Values from Another Table
o Creating and Using Macro Variables
• SAS Macro Overview
• SAS Macro Variables
• Scope of Macro variables
• Defining SAS Macros
• Inserting Comments in Macros
• Macros with Arguments
• Conditional Macros
• Macros Repeating PROC Execution
• Macro Language
• SAS Macro Processor


Course Name: Clinical Data Management