You’ll learn how to apply data manipulation and optimization techniques; advanced statistical concepts like clustering, linear regression and decision trees; data analysis methods to solve real world business problems and predictive modeling techniques. This SAS Certification course will give you practical knowledge you can apply on your next data analysis job.

SAS Training Outline (SAS Base and Advance)

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 Statement with Options
  • Working With External Files & Options
  • Multiple Observations
  • Input Styles
  • Select Statement
  • Leave and Continue Statements
  • Creating & Redefining Variables
  • Where Statement
  • If – Then Else Statement
  • Goto, Stop And Error Statements
  • Output Statement, Put Statement
  • Do Loops (do while, do until)
  • Modifying And Combining Data Sets
  • Updating Master Data Set
  • Display Manager Commands
  • SAS Functions( Character, date and time, special, numeric)
  • An Introduction To Arrays And Array Processing ( single array, multidimensional array)
  • Overview Of Methods For Combining Sas Data Sets

BASE SAS PROCEDURES

  • Proc sort
  • Proc Print
  • Proc Means
  • Proc Freq
  • Proc Plot
  • Proc Chart
  • Proc Copy
  • Proc Summary
  • Proc Append
  • Proc Transpose
  • Proc Datasets
  • Proc Contents
  • Proc Delete
  • Proc Format
  • Proc Import
  • Proc Export
  • Proc Report
  • Proc Tabulate
  • Proc Summary

Advanced SAS

  • Introduction To SAS/ SQL
  • Features
  • Uses
  • Terminology
  • Data Types, Key Words, & Operators
  • Functions, Predicates
  • Formatting Output
  • Descriptive Function (sum, std, min, max, count, nmiss, var,mean)
  • Working with Calculate, monotonic, distinct, Coalesce
  • Where Clause (like, contain)
  • In, not in, Exist, not exist, any, all
  • Group By Clause
  • Order By Clause
  • Having Clause
  • Case Expression And Conditional Logic.
  • Creating ,Populating & Deleting Tables
  • Sub Query
  • Alter Table Statement
  • Insert, update, Drop
  • Changing Column’s Length
  • Horizontal Joins (full, inner,outer,left,right,cross join)
  • Vertical Joins (union, union all, intersect,intersct all,except and except all)
  • Constraints
  • Renaming table & Columns
  • Index
  • Views

SAS/MACROS

  • Macro Concepts
  • Macro processor (input stack, token.)
  • Global Symbol Table and Local Symbol Table
  • Global and Local Variables
  • 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
  • Macro Option
  • Automatic Variable
  • Macro Functions
  • Including External Macros
  • Macro Stored Procedure(%include, Autocall macro, mstored)
  • Macro Quote Function(%Bquote,NBquote, Str, Nstr,SuperQ)

SAS/ODS

  • Creating RTF File
  • Creating Html File
  • Creating Pdf File

SAS/GRAPH

  • Chart Procedure
  • Vertical, Horizontal, Pie,star,donot
  • Group, Subgroups
  • Plot Procedure,(boxplot, scatter plot)
  • Multiple Plots & Overlay
  • Symbol Statement
  • Title And Footnote Statements

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/STAT

  • Proc Univariate
  • Proc Corr
  • Proc Reg
  • Proc Anova
  • Proc Ttest

Production4