SAS Clinical Online Training Course Content

INTRODUCTION

• Introduction of SAS software
• Industries using SAS
• Components of SAS System
• Architecture of SAS system
• Functionality of SAS System
• Introduction of SAS windows

Working in the SAS Environment

• Functionality of SAS Windows
• Creating and managing SAS Libraries
• Overview of SAS Data states
• Types of Libraries
• Storing files temporarily and permanently
• Referencing SAS files

CREATION DATABASE FROM RAWDATA

• Steps to create a SAS dataset
• Creating SAS dataset using text file
• Creating SAS dataset using text file with delimiters
• Creating SAS dataset using structured text file
• Creating SAS dataset using unstructured text file
• Creating SAS dataset using Excel file
• Creating SAS dataset using Access file
• Creating SAS dataset using values inside the code

CREATING AND REDEFFING VARIABLES

• Use with different conditional statements

DEBUGGING ERROR MESSAGES

• DEBUGGING syntax ERROR MESSAGES

AUTOMATIC VARIABLES

• Use of automatic variables
• Types of automatics variables
• Use of _N_, _ERROR_, _NULL_
• Testing your programs
• Using put statement
• Automatic Variable

Output delivery system

• Concepts of output delivery system
• How ODS works and viewing output of ODS in different format
• HTML, RTF, PDF etc.

COMBINATION the dataset

• One-o-one reading
• One to many
• Many to many
• Concatenation
• Interleaving
• Match merge

Functions

• Character function
• Numerical function
• Arithmetical function
• Mathematical function
• Date Function

Sampling method

• Random sampling

Loops in SAS : Do Loops

• Loops are used to iterate through every observation for specified number of times to obtain a desired result
• Types of Loops:
  • Do Loop
  • Do While
  • Do Until
• Default increments by 1
• Can use BY to increment by any value other than 1

Array

• Definition of array
• Example of array

PROCEDURES IN BASE SAS

• Procedure Format
• Procedure Contents
• Procedure Options
• Procedure Append
• Procedure Compare
• Procedure Transpose
• Procedure Print
• Procedure Import
• Procedure Export
• Procedure Datasets
• Procedure Tabulate
• Procedure Chart, Gchart, Gplot
• Procedure Report

GRAPHS

• Introduction to graphics
• Introduction to graphics
• Types of Graphics (with latest models)
• Defining procedure Graphics

Advance SAS Topic

Proc Sql

• Generate detail reports by working with a single table, joining tables, or using set operators in the SQL procedure
• Generate summary reports by working with a single table, joining tables, or using set operators in the SQL procedure
• Construct sub-queries and in-line views within an SQL procedure step
• Compare solving a problem using the SQL procedure versus using traditional SAS programming techniques
• Access Dictionary Tables using the SQL procedure

Macro

• Create and use user-defined and automatic macro variables within the SAS Macro Language
• Automate programs by defining and calling macros using the SAS Macro Language
• Understand the use of macro functions

SAS Clinical Programming

Introduction of SAS and Clinical research

• SAS role in Clinical Research
• What is Clinical trial?
• What is Protocol and role of Protocol in Clinical Research?
• Which is playing main role in Clinical Research?

Clinical Trials Data Structures

Identify the classes of clinical trials data (demographic, lab, baseline, concomitant medication, etc.)

Identify key CDISC principals and terms

CDISC SDTM data model

• What is SDTM
• Purpose of SDTM
• Domain
• Variables
• Role Concept
• Core Variable Concept
• General Observation Classes
• Controlled Terminology
• SDTM Mapping Process
• DESIGN AND IMPLEMENTATION
• SAS Program for NON SDTM to SDTM
• Implement SDTM concept on SAS using live project

Creating SDTM Tabulations(Datasets)

6 Different types of SDTM Datasets

• DM
• SUPPDM
• Findings - LB
• Events - AE
• Interventions - EX
• Trial design datasets – TA,TE,TI,TS,TV

CDISC ADAM data model

• What is ADAM
• Fundamental principles
• Traceability
• ADaM datasets workflow
• ADaM Related Process
• Data Metadata
• Variable Metadata
• Variable Value Level Metadata
• Controlled Terminology/Code Lists
• Core variables
• The ADaM Standard
  • ADSL
  • BDS

Implement ADAM concept on SAS using live project

Creating ADAM (Datasets)

4 Different types of ADAM Datasets

• ADSL
• ADAE
• ADEF
• ADtte

Describe the contents and purpose of define.xml

Statistic and Report Clinical Trials Results

• Use SAS procedures to obtain descriptive statistics for clinical trials data (FREQ, UNIVARIATE, MEANS, SUMMARY)
• Create output data sets from statistical procedures
• Using ODS with PROC REPORT and PROC TABULATE to generate nice looking tables and listings
• Producing Bar and Pie charts using PROC GPLOT and PROC GCHART

Transform Clinical Trials Data

• Apply categorical and windowing techniques to clinical trials data
• Transpose SAS data sets
• Apply ‘observation carry forward’ techniques to clinical trials data (LOCF, BOCF, WOCF)
• Calculate ‘change from baseline’ results
• Windowing concept

Clinical Project

• 1 Project (SDTM)
• 1 Project (ADAM)
• 5 Project (TLF)

Basic Statistic

• Data Exploration
• Data Preparation
• Summary Statistics
  • Summary Statistics - Central Tendency
  • Summary Statistics - Central Tendency
  • Introduction to Statistics - Descriptive Statistics
  • Introduction to Statistics -Samples and Populations
• Hypothesis Testing
  • Concept of hypothesis testing
  • Chisq
  • Anova

Additional Support:

• Clinical Project
• Resume preparation
• Interview questions