Enquire
IT Consulting and Training Website Development Recruitment Consulting
SAS        Course Details (PDF)     

Course Contents

  • Part I: SAS/BASE
    • 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 Statements with Options
    • Working with External Files & Options
    • Multiple Observations
    • Input Styles
    • Select Statement
    • Leave and Continue Statements
    • Retain Statement
    • Creating & Redefining Variables
    • Where Statement
    • If-Then Else Statement
    • Goto, Stop and Error Statements
    • Output Statement, Put Statement
    • Do Loops
    • Array Statement
    • Date Informats, Formats
    • Date and Time Functions
    • Modifying and Combining Data Sets
    • Updating Master Data Set
    • Key Board Macros & Add Abbreviations
    • Display Manager Commands
    • SAS Functions
    • Finding Duplicate Observations

  • Base SAS Procedures
    • 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

  • Part II: SQL Concepts
    • Introduction
    • History
    • Features
    • Sql Command Set
    • Operators in Sql
    • Order By Clause
    • Group By Clause
    • Having Clause
    • Distint Clause
    • Create and Insert
    • Deleting, Populating and Updating
    • Sub Queries
    • View and Joins

  • SAS/SQL
    • Introduction to Sas/Sql
    • Features
    • Uses
    • Terminology
    • Data Types, Keywords and Operators
    • Functions, Predicates
    • Formatting Output
    • Group By Clause
    • Order By Clause
    • Having Clause
    • Case Expression and Conditional Logic
    • Creating, Populating and Deleting Tables
    • Constraints
    • Alter Table Statement
    • Changing Column's Length
    • Joins
    • Constraints
    • Renaming a Table and Columns
    • Views

  • SAS/ACCESS
    • Working with Oracle
    • Working with MS-Access
    • Working with MS-Excel and other Database files
    • DbLoad Procedure

  • SAS/GRAPH
    • Gchart Procedure
    • Vertical, Horizontal, Pie
    • Donut
    • G3d
    • Group, Subgroups
    • Gplot Procedure
    • Multiple Plots and 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 & Call Symput
    • Including External Macros

  • SAS/STAT
    • Proc Univariate
    • Proc Corr
    • Proc Reg
    • Proc Anova

  • SAS/ODS
    • Creating Rdf File
    • Creating Html File
    • Creating Pdf File

  • 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: (Any one Project)
    • Clinical Project
    • Banking Project

  • Note: Free Course Material