Advanced JobOriented SAS training

  • Software Tools Used : (SAS 9.2 With SAS Certification & Non SAS Certification)
    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
    • 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
    • Proc Rank
    • Proc Transpose

     

  • SAS/WAREHOUSE ADMINISTRATOR 2.3

    • 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
    • Banking Project
    • healthcare project

     

  • Note: 1.Free Course Material & Certification Guidance. 
                 2. Fast Track & Weekend Batches Are Also There.