SAS Clinical Course Content
Hours 30 Hours
BASE SAS 
Introduction To SAS & History 
SAS System Architecture & Functionalities 
Features of SAS 
Various Domines And Modules in SAS 
SAS Statements And Syntax Rules 
SAS Variables, Data Set Names & Terminology 
SAS Windows 
SAS Data Sets & SAS Comments 
Parts of SAS Program 
Reading Multiple Observations & Global Statements 
Reading Raw Data With Infile Statement With Options 
Set Statement & Data Set Options 
Operators 
Where Statement 
If – Then Else Statement 
Creating & Redefining Variables 
Updating Master Data Set 
Select Statement 
Do Loops 
Creating Multiple Data sets using Output Statement 
Leave and Continue Statements 
Retain Statement And GOTO Statement 
STOP and ERROR Statements 
Input Styles (1.List Input 2.Column Input 3. Formatted Input) 
SAS Functions
            1.Character
            2.Date & Time 
            3. Statistical
            4.MathematicalSpecial Functions 
Modifying And Combining Data Sets (Merging) 
Deleting And Finding Out Duplicate ID’S 
Put Statement and Arrays 
Key Board Macros, Add Abbreviations And Display Manager Commands 
BASE/SAS PROCEDURES 
Proc Sort 
Proc Print 
Proc Copy  
Proc Contents 
Proc Delete 
Proc Format
Proc Compare 
Proc Append 
Proc Plot 
Proc Chart 
Proc Printto 
Proc Transpose 
Proc Format 
Proc Import 
Proc Export 

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 
Sub Queries, Views and Joins 
Integrity Constraints 

SAS/SQL 
Introduction To SAS/SQL 
Features, Uses And Terminology 
Data Types, Key Words, & Operators 
Functions, Predicates 
Formatting Output 
Order By Clause 
Group By Clause 
Having Clause 
Case Expression And Conditional Logic. 
Creating ,Populating, Deleting Rows & Dropping Tables 
Alter Table Command (Updating & Changing Column’s Length) 
Changing Column’s Formats 
Renaming A Table & Columns 
Joins And Views 
Integrity Constraints 

SAS/REPORTS AND TABULATIONS 
Frequency Report 
One-Way Frequency Report 
Cross Tabular Frequency Report 
Summary Statistics 
Creating A List Report 
Define Statement 
Order Usage and Group 
Printing Grand Totals 
Rbreak Statement 
Tabulate Procedure 
One-Dimensional Tables 
Two-Dimensional Tables 
Obtaining A Total 
Analysis Variables with options 
Summary Statistics 

SAS/GRAPHS AND SAS PLOTS 
Gchart Procedure 
Vertical, Horizontal, Pie & Donut 
Discrete, Sumvar And Type Options 
Fill & Explode Options 
Group, Subgroups 
Title And Footnote Statements 
Goptions 
Gplot Procedure & G3d Procedure 
Multiple Plots & Overlay 
Symbol Statement & Interpolation Options 

SAS/MACROS 
Macro Concepts & Advantages 
Macros And Macro Variables 
Creating Macro Variables & Using Macro Variables 
Invoking A Macro 
Adding Parameters To Macros 
Writing Macros With Conditional Logic 
Using Various Procedures In Macros 
External Macros & Automatic Macro Variables 
Nesting of Macros 
Multiple And Multi-Level Macros 
Macro Functions 

SAS/ODS 
Creating PDF File 
Creating HTML File 
Creating RTF File 

SAS/STAT 
Proc Univariate 
Proc Freq
Proc Ttest 
Proc Anova 
Proc Npar1way


SAS/PROJECTS( Only One Project ) 
CLINICAL PROJECT 
Shared publiclyView activity