SAS Clinical Data Management

SAS Clinical Data Management

  • 16 weeks
  • 96 hours

This course is designed to teach students the skills necessary to manage clinical trial data using SAS software. Students will learn how to use Base SAS and Advanced SAS to clean, transform, analyze, and report on clinical trial data.

Course Overview

The course will begin with a review of the basics of SAS programming, including the DATA step, procedures, and libraries. Students will then learn how to use SAS to prepare and manage clinical trial data, including:

  • Importing and exporting data
  • Creating and managing SAS datasets and tables
  • Performing data cleaning and transformation
  • Merging and splitting datasets
  • Creating derived variables



This course offers a number of advantages over other CDM courses, including:

  • It is comprehensive, covering all aspects of CDM from data import and preparation to data analysis and reporting.
  • It uses SAS, which is the industry standard software for CDM.
  • It is taught by experienced professionals who have worked in the clinical trials industry.
  • It provides global certification exam support, so you can be confident that you are learning the skills you need to succeed in your career.


What you'll learn
  • Statistical Analysis Software

  • Base SAS

  • Proc SQL and Macro

  • Components of the Statistical Analysis Software
  • Data-Driven Tasks
  • Turning Data into Information
  • Introducing to Statistical Analysis Software Programs
  • Running Statistical Analysis Software Programs
  • Mastering Fundamental Concepts
  • Diagnosing and Correcting Syntax Errors
  • Statistical Analysis Software Data Libraries
  • Getting Started with the PRINT Procedure
  • Sequencing and Grouping Observations
  • Identifying Observations
  • Special WHERE Statement Operators
  • Customizing Report Appearance
  • Formatting Data Values
  • Creating HTML Reports
  • Reading Raw Data Files: Column Input
  • Reading Raw Data Files: Formatted Input
  • Examining Data Errors
  • Assigning Variable Attributes
  • Changing Variable Attributes
  • Reading Excel Spreadsheets
  • Reading Data Sets and Creating Variables
  • Conditional Processing
  • Dropping and Keeping Variables
  • Reading Excel Spreadsheets Containing Date Fields
  • Concatenating Data Sets
  • Merging Data Sets
  • Combining Data Sets : Additional Features
  • Introduction to Summary Reports
  • Basic Summary Reports
  • The Report Procedure
  • The Tabulate Procedure
  • Producing Bar and pie Chart
  • Enhancing output
  • Producing Plots
  • Overview
  • Review
  • Review of DATA Step Processing
  • Review of Displaying Data Sets
  • Working with Existing Data Sets
  • Outputting Multiple Observations
  • Writing to Multiple Data Sets
  • Selecting Variables and Observations
  • Writing to an External File
  • Creating an Accumulating Total variable
  • Accumulating Totals for a Group of Data
  • Reading Delimited Raw Data Files
  • Controlling When a Record Loads
  • Reading Hierarchical Raw data Files
  • Introduction
  • Manipulating Character values
  • Manipulating Numeric values
  • Manipulating Numeric values based on Dates
  • Converting variable Type
  • Using the PUT Statemen
  • Using the DEBUG Option
  • Do Loop Processing
  • Array Processing
  • Using Arrays
  • Match-merging Two or more Data Sets
  • Simple Joins Using the SQL Procedure
  • Mastering Fundamental Concepts
  • Diagnosing and Correcting Syntax Errors
  • What is SQL?
  • What is the SQL Procedure?
  • Terminology
  • Comparing PROC SQL with the DATA step
  • Note about the Example Table
  • Overview of the select Statement
  • Selecting Columns in a Table
  • Creating New Columns
  • Sorting Data
  • Retrieving rows that satisfy a Condition
  • Summarizing Data
  • Grouping Data
  • Filtering Grouped Data
  • Introduction
  • Selecting Data from More Than One Table by Using joins
  • Using Subqueries to Select Data
  • When to Use Joins and Subqueries
  • Combining Queries with Set Operators
  • Introduction
  • Creating Tables
  • Inserting Rows into Tables
  • Updating Data Values in a Table
  • Deleting Rows
  • Altering Columns
  • Creating an Index
  • Deleting a Table
  • Using SQL Procedure Tables in Statistical Analysis Software
  • Creating and Using Integrity Constraints in a Table
  • Introduction
  • Using Proc SQL Options to Create and Debug Quires
  • Improving Query Performance
  • Accessing System Information Using DICTIONARY Tables
  • Using Proc SQL with the Macro Facility
  • Formatting PROC SQL output Using the Report Procedure
  • Accessing a DBMS
  • Overview
  • Computing a Weighted Average
  • Comparing Tables
  • Overlaying Missing Data Values
  • Computing Percentages within Subtotals
  • Counting Duplicate Rows in a Table
  • Expanding Hierarchical Data in a Table
  • Summarizing Data in Multiple Columns
  • Creating a Summary Report
  • Creating a Customized Sort Order
  • Conditionally Updating a Table
  • Updating a Table with Values from Another Table
  • Creating and Using Macro Variables
  • Macro Overview
  • Macro Variables
  • Scope of Macro variables
  • Defining Macros
  • Inserting Comments in Macros
  • Macros with Arguments
  • Conditional Macros
  • Macros Repeating PROC Execution
  • Macro Language
  • Macro Processor
Admission Process

Please call to admission counselor for course fees, registration fees, EMI fecilities,registration form and other formalities. Contact to admission counselor


Who Can Join?

Any graduate with knowledge of basic computing.


1. Personal computer/laptop with webcam and microphone

2. Stable internet connections

Payment Details

Bank Details:
Account Number: 19700200000420
IFSC Code: BARB0SALTLA (5th letter is numeric zero)
UPI Payment: 9432257052@okbizaxis

  • Live Instructor-Led Course
  • Project and Case Studies
  • Certificate of completion
  • Learn from Experts
  • Placement Assistance