Course Content

SAS ONLINE TRAINING

 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
 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
 Stop And Error Statements
 Array Statement
 Modifying And Combining Data Sets
 Updating Master Data Set
 Key Board Macros & Add Abbreviations
 Display Manager Commands

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/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/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, Predicates & Functions
 Formatting Output
 Group By Clause, Order By Clause & Having Clause
 Case Expression and Conditional Logic.
 Creating ,Populating & Deleting Tables
 Alter Table Statement
 Renaming A Table & Columns
 Changing Column’s Length
 Joins & Views
SAS/ACCESS
 Import & Export Procedures
 Importing data from Ms-Access & Ms-Excel
 Importing data from Oracle database
 DbLoad Procedure
SAS/GRAPH
 Gchart Procedure
 Vertical, Horizontal, Pie
 Donut
 Group,Subgroups
 Gplot Procedure
 Mutliple Plots & Overlay
 Symbol Statement
 Title and Footnote Statements
 Goptions
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/WAREHOUSE ADMINISTRATOR
 Introduction To DW
 Relationship Between SAS And Data Warehousing
 Database Designing
 Types Of Schema
 Global Warehouse Designing Steps
SAS/ETL
 Introduction To ETL
 Application Of ETL In DW
 ETL Process Model Development In SAS With Project

PART-III (Only One Project)
 CLINICAL PROJECT
 FINANCE PROJECT