About SAS

Day 1 :
 Introduction To SAS System & Architecture
 Brief discussion on SAS Product Suites.
 Introduction to ETL and Reporting Concepts.
 Introduction to SAS interface.
 The Microsoft Windows User Interface
 The Editor Window
 The Log window
 Output Window
 Explorer Window
 Results Window
 SAS Variables & Datasets.
 Dataset Options with examples.
 Operators in sas.
 Introduction to SAS Libraries and options.
 Reading Raw data
 Infile Statement With Options
 Working With External Files & Options
 Handling multiple observations.

Day 2:
 Input

 Date Functions
 Mathematical & Numerical Functions
 SAS ODS :
· Creating RTF File
· Creating Html File
· Creating Pdf File

Day 3:
 Conditional Execution on SAS.
 Where
 If/Else
 Case statement
 Do loops
 Merging in SAS
 First. And last.
 Overview Of Methods For Combining Sas Data Sets.
 Creating and drooping variables in a dataset.
 Arrays and Array Processing.

BASE SAS PROCEDURES
 Proc sort
 Proc Print
 Proc Means
 Proc Freq
 Proc Copy
 Proc Summar
 Proc Append
 Proc Dataset
 ProcContents
 Proc Delete
 Proc Format
 Proc Import
 Proc Export
 · Frequency Report
 · One-Way Frequency Report
 · Cross Tabular Frequency Report
 · Summary Statistics

Day 4:
 Creating A List Report
 · Define Statement
 · Order Usage and Group
 · Tabulate Procedure
 · One-Dimensional Tables
 · Two-Dimensional Tables
 · Obtaining A Total
 · Analysis Variables with options
 · Summary Statistics

Introduction to SAS Sql:
 · Introduction To SAS/ SQL
 Features
 ·Uses
 Terminology

Data Types, Key Words, & Operators
 · 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
 · Renaming A Table & Columns
 · Views

Day 5 :
 Introduction to 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