(678) 643-7777
(678) 248-0302

SAS Training course, Certification

 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
Watch BA Video

summer-java-ap-new-copy