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