The focus of the lectures will be mainly on the following

topics:

Our Course syllabus in SAS:-

• Base SAS training

• Advance SAS training

• Clinical SAS Training with Project

• SAS certification

Clinical SAS Course Content:

• Introduction To Sas And Clinical research

• SAS role in Clinical Research

• Project Management in Clinical Research

• What is Clinical Research?

• What is Protocol and role of Protocol in Clinical

Research?

• What is randomization and non randomization?

• Which is playing main role in Clinical Research?

• What is SOP (Standard Operating Procedure)

• Role of DBMS team in Clinical Research

• What is CDM (Clinical Data Management)?

• Importance of CDM systems for data loading

• What is SAP (Statistical Analysis Plan)?

• Role of SAP in Clinical Research

• SAS Work Flow in Clinical Research

• Relation between SAS and DBMS

• Interaction between SAS with CDMs for data access

• Various report generation in Clinical Research

PART-I

BASE SAS:

• Introduction To SAS System & Architecture

• History And Various Modules

• Variables & SAS Syntax Rules

• SAS Data Sets

• Data Set Options

• Operators

• If – Then Else Statement

• Where Statement

• Creating & Redefining Variables

• Reading Raw Data

• Infile Statement With Options

• Multiple Observations and Multiple Datasets.

• Input Styles

• SAS Functions

• Select Statement

• Do Loops

• Output Statement & Put Statement

• Stop And Error Statement s

• Array Statement

• Modifying And Combining Data Sets

• Updating Master Data Set

• Key Board Macros & Add Abbreviations

BASE SAS PROCEDURES

• Proc Sort

• Proc Print

• Proc Means

• Proc Freq

• Proc Plot

• Proc Chart

• Proc Compare

• Proc Copy

• Proc Summary

• Proc Append

• Proc Datasets

• Proc Contents

• Proc Delete

• Proc Format

• Proc Printto

• SAS/ODS:

• Creating Rtf File

• Creating Html File

• Creating Pdf File

• Creating Xml File

PART –II

ORACLE-SQL CONCEPTS:

• Introduction

• History

• Features

• Sql Command Set

• Operators In Sql

• Order By Clause

• Group By Clause

• Having Clause

• Distinct Clause

• Create and Insert

• Deleting, Populating And Updating

• SAS/SQL:

• Introduction To SAS/SQL

• Features & Uses

• Terminology

• Data Types, Key Words, & Operators

• Functions, Predicate s & Functions

• Formatting Output

• Group By Clause, Order By Clause & Having Clause

• Case Expression and Condition al Logic.

• Creating ,Populating & Deleting Tables

• Alter Table Statement

• Renaming A Table & Columns

• Changing Column's Length

• Joins & Views

SAS/ACCESS:

• Import & Export Procedure s

• Importing data from Ms-Access & Ms- Excel

• Importing data from Oracle database

• DbLoad Procedure

• SAS/GRAPH :

• Gchart Procedure

• Vertical, Horizonta l, Pie

• Donut

• Group, Subgroups

• Gplot Procedure

• Mutliple Plots & Overlay

• Symbol Statement

• Title and Footnote Statement s

• Goptions

• SAS/MACROS :

• Macro Concepts

• Macros And Macro Variables

• Creating Macro Variables

• Using Macro Variables

• Creating Modular Code With Macros

• Invoking A Macro

• Adding Parameter s To Macros

• Macros With Condition al Logic

• Using Various Procedure s In Macros

• Automatic Variables

• Macro Functions