SAS Analyst / Programmer

SAS Analyst / Programmer

SAS is the leader in analytics. Through innovative software and services, SAS empowers and inspires customers around the world to transform data into intelligence. SAS gives you THE POWER TO KNOW.

SAS is a trusted analytics powerhouse for organizations seeking immediate value from their data. A deep bench of analytics solutions and broad industry knowledge keep our customers coming back and feeling confident. With SAS, you can discover insights from your data and make sense of it all. Identify what’s working and fix what isn’t. Make more intelligent decisions. And drive relevant change.

BASE SAS
  • Introduction To SAS & History
  • SAS System Architecture & Functionalities
  • Features of SAS
  • Various Domines And Modules in SAS
  • SAS Statements And Syntax Rules
  • SAS Variables, Data Set Names & Terminology
  • SAS Windows
  • SAS Data Sets & SAS Comments
  • Parts of SAS Program
  • Reading Multiple Observations & Global Statements
  • Reading Raw Data With Infile Statement With Options
  • Set Statement & Data Set Options
  • Operators
  • Where Statement
  • If – Then Else Statement
  • Creating & Redefining Variables
  • Updating Master Data Set
  • Select Statement
  • Do Loops
  • Creating Multiple Data sets using Output Statement
  • Leave and Continue Statements
  • Retain Statement And GOTO Statement
  • STOP and ERROR Statements
  • Input Styles (1.List Input 2.Column Input 3. Formatted Input)
  • SAS Functions
Mathematical Special Functions:
  • Modifying And Combining Data Sets (Merging)
  • Deleting And Finding Out Duplicate ID’S
  • Put Statement and Arrays
  • Key Board Macros, Add Abbreviations And Display Manager Commands
BASE/SAS PROCEDURES:
  • Proc Sort
  • Proc Print
  • Proc Copy
  • Proc Contents
  • Proc Delete
  • Proc Format
  • Proc Compare
  • Proc Append
  • Proc Plot
  • Proc Chart
  • Proc Printto
  • Proc Transpose
  • Proc Format
  • Proc Import
  • Proc Export
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
  • Sub Queries, Views and Joins
  • Integrity Constraints
SAS/SQL:
  • Introduction To SAS/SQL
  • Features, Uses And Terminology
  • Data Types, Key Words, & Operators
  • Functions, Predicates
  • Formatting Output
  • Order By Clause
  • Group By Clause
  • Having Clause
  • Case Expression And Conditional Logic.
  • Creating ,Populating, Deleting Rows & Dropping Tables
  • Alter Table Command (Updating & Changing Column’s Length)
  • Changing Column’s Formats
  • Renaming A Table & Columns
  • Joins And Views
  • Integrity Constraints
SAS/REPORTS AND TABULATIONS:
  • 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/GRAPHS AND SAS PLOTS:
  • Gchart Procedure
  • Vertical, Horizontal, Pie & Donut
  • Discrete, Sumvar And Type Options
  • Fill & Explode Options
  • Group, Subgroups
  • Title And Footnote Statements
  • Goptions
  • Gplot Procedure & G3d Procedure
  • Multiple Plots & Overlay
  • Symbol Statement & Interpolation Options
SAS/MACROS:
  • Macro Concepts & Advantages
  • Macros And Macro Variables
  • Creating Macro Variables & Using Macro Variables
  • Invoking A Macro
  • Adding Parameters To Macros
  • Writing Macros With Conditional Logic
  • Using Various Procedures In Macros
  • External Macros & Automatic Macro Variables
  • Nesting of Macros
  • Multiple And Multi-Level Macros
  • Macro Functions
SAS/ODS:
  • Creating PDF File
  • Creating HTML File
  • Creating RTF File
SAS/STAT:
  • Proc Univariate
  • Proc Freq
  • Proc Ttest
  • Proc Anova
  • Proc Npar1way