PART-I

• BASE SAS
• Introduction To SAS System & Architecture
• History And Various Modules
• Features
• Variables & SAS Syntax Rules
• SAS Data Sets
• Data Set Options
• Operators
• Reading Raw Data
• Infile Statement With Options
• Working With External Files & Options
• Multiple Observations
• Input Styles
• Select Statement
• Leave and Continue Statements
• Creating & Redefining Variables
• Where Statement
• If – Then Else Statement
• Goto, Stop And Error Statements
• Output Statement, Put Statement
• Do Loops
• Modifying And Combining Data Sets
• Updating Master Data Set
• Display Manager Commands
• SAS Functions
• BASE SAS PROCEDURES
• Proc sort
• Proc Print
• Proc Means
• Proc Freq
• Proc Plot
• Proc Chart
• Proc Copy
• Proc Summary
• Proc Append
• Proc Datasets
• Proc Contents
• Proc Delete
• Proc Format
• Proc Import
• Proc Export

 

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, Predicates
• Formatting Output
• Group By Clause
• Order By Clause
• Having Clause
• Case Expression And Conditional Logic.
• Creating ,Populating & Deleting Tables
• Alter Table Statement
• Changing Column’s Length
• Joins
• Constraints
• Renaming A Table & Columns
• Views
• SAS/ACCESS
• Working With Oracle
• Working With Ms-Access
• Working With Ms-Excel
• DBLoad Procedure
• SAS/GRAPH
• Gchart Procedure
• Vertical, Horizontal, Pie
• Donut
• G3d
• Group, Subgroups
• Gplot Procedure
• Multiple Plots & Overlay
• Symbol Statement
• Title And Footnote Statements
• Goptions
• SAS/REPORTS
• 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/MACROS
• Macro Concepts
• Macros And Macro Variables
• Creating Macro Variables
• Using Macro Variables
• Creating Modular Code With Macros
• Invoking A Macro
• Adding Parameters To Macros
• Macros With Conditional Logic
• Using Various Procedures In Macros
• Automatic Variables
• Macro Functions
• Including External Macros
• SAS/STAT
• Proc Univariate
• Proc Corr
• Proc Reg
• Proc Anova
• SAS/ODS
• Creating Rtf File
• Creating Html File
• Creating Pdf File