• Introduction To SAS System & Architecture
• History And Various Modules
• Features
• 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
• Leave and Continue Statements
• Output Statement & Put Statement
• Goto, Stop And Error Statements
• Array Statement
• Modifying And Combining Data Sets
• Updating Master Data Set
• Key Board Macros & Add Abbreviations
• Display Manager Commands

2. 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 Import
Proc Export
Proc Printto

3. 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