SAS Certification COURSE

Foundation Tools

• Programming
• SAS Grid Manager
• SAS Enterprise Guide

Advanced Analytics

• Statistical Analysis
• Data Scientist
• Forecasting and Econometrics
• Data Mining
• Predictive Analytics and Machine Learning
• Text Analytics
• Optimization and Simulation
• JMP Statistical Analysis

Business Intelligence and Analytics

• SAS Office Analytics
• SAS Visual Analytics
• SAS Enterprise Business Intelligence

Internet of Things

• Internet of Things

Data Management

• Data Integration
• Data Quality
• Data Governance
• SAS/ACCESS

Administration

• SAS Platform
• Application/Technology Area
• Solutions

SAS Solutions

• Customer Intelligence
• Fraud and Security Intelligence
• Risk Management
• Integrated Merchandise Planning
• Health and Life Sciences
• Supply Chain Intelligence
• Performance Management

The SAS certification program is divided into 2 parts i.e. Base SAS and Advanced SAS. Given below the course subjects in Base SAS and Advanced SAS:-

Base SAS Syllabus

Working with Windows

• Enhance Editor
• Result Window
• Log Window
• Explorer Window
• Output Window
• Program Editor Window

Basics of SAS Language

• SAS Libraries
• Data Sets
• Creating a SAS Program
• Components
• Characteristics
• The layout of the SAS Program

Accessing Data

• Use FORMATTED, LIST, and COLUMN input to read raw data files
• Use INFILE statement options to control processing when reading raw data files
• Use various components of an INPUT statement to process raw data files including column and line pointer controls, and trailing controls
• Combine SAS data sets using the DATA

Creating SAS Datasets

• Create temporary and permanent SAS data
• Create and manipulate SAS date values
• Control which observations and variables in a SAS data set are processed and output
• Program Data Vector (PDV)
• Execution Phase and Compilation Phase
• Get Started with the Output Delivery System (ODS)

Statement Options

• Global Statements
• Local Statements
• List Input
• Modified Input
• Column Output
• Named Input

Combining SAS Datasets

• Concatenation
• One-One Merging
• Match Merging
• One-One Reading
• Updating/Setting

Merging Data

• Exploring SAS data libraries using base SAS utility procedures
• Sorting observations in a SAS data set
• Conditionally execute SAS statements
• Use assignment statements in the DATA step
• Modify variable attributes using options and statements in the DATA step
• Use SAS functions to manipulate character data, numeric data, and SAS date values
• Use SAS functions to convert character data to numeric and vice versa

Conditional Statements

• IF & IF-THEN statement
• IF ELSE statement
• Where condition
• Like, Into Statements
• Loops (Do, While)

Generating Reports

• Generate list reports using the PRINT and REPORT procedures
• Enhance reports through the use of labels, SAS formats, user-defined formats
• Generate summary reports and frequency tables using base SAS procedures

Debugging and Handling Errors

• Identify and resolve programming logic errors
• Checking for Errors, Warnings, Un-Initialization, missing values
• Recognize and correct syntax errors
• Examine and resolve data errors

Procedures

• Proc Sort
• Proc Transpose
• Proc Print
• Proc Print
• Proc Contents
• Proc Formats
• Proc Append
• Proc Tabulate
• Proc Options
• Proc Report
• Proc Import
• Proc Export
• Proc Freq
• Proc Means

Accessing Data

• Use FORMATTED and LIST input to read raw data files
• Use INFILE statement options to control processing when reading raw data files
• Input Styles Combine SAS data sets
• Access an Excel workbook
• Creating Data Structures
• Create temporary and permanent
• SAS data sets Create and manipulate SAS date values Export data to create standard and comma-delimited raw data files
• Managing Data
• Investigate SAS data libraries using base SAS utility procedures
• Sort observations in a SAS data set Conditionally execute SAS statements
• Use assignment statements in the
• DATA step
• Modify variable attributes using options and statements in the DATA step
• Accumulate subtotals and totals using DATA step statements
• Use SAS functions to manipulate character data, numeric data, and SAS date values
• Use SAS functions to convert character data to numeric and vice versa
• Process data using DO LOOPS
• Process data using SAS arrays
• Validate and clean data
• Generating Reports
• Generate list reports using the
• PRINT procedure Accessing Data
• Generate summary reports and frequency tables using base SAS procedures
• Enhance reports through the use of user-defined formats, titles, footnotes, and SAS
• System reporting
• Generate reports using ODS statements
• Handling Errors
• Identify and resolve programming logic errors
• Recognize and correct syntax errors
• Examine and resolve data errors

Advanced SAS Syllabus

Introduction to SAS System & Architecture

• History And Various Modules
• Variables & SAS Syntax Rules
• Data Set Options
• If-Then-Else Statement
• Creating & Redefining Variables
• In file Statement With Options
• Input Styles
• Select Statement
• Output Statement & Put Statement
• Array Statement
• Updating Master Data Set
• Display Manager Commands
• Features
• SAS Data Sets
• Operators
• Where Statement
• Reading Raw Data
• Multiple Observations and Multiple Datasets
• SAS Functions
• Do Loops & Leave and Continue Statements
• Stop And Error Statements
• Modifying And Combining Data Sets
• Keyboard Macros & Add Abbreviations

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 Print

SAS Reports

• Frequency Report
• One-Way Frequency Report
• Cross Tabular Frequency Report
• Summary Statistics
• Creating the A-List Report
• Define Statement
• Order Usage and Group Features
• Uses & Terminology Data Types
• Key Words & Operators Functions
• Predicate & Functions Formatting
• Output Printing Grand Totals
• R break 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

Oracle’s SQL Concepts

• History
• Features
• SQL Command Set – DDLs & DMLs

SAS’s SQL

• Features, Uses & Terminology
• Data Types, Key Words, & Operators
• Functions, Predicate s & Functions
• Formatting Output Group By Clause,
• Order By Clause & Having Clause
• Case Expression and Conditional Logic
• Creating, Populating & Deleting
• Tables Alter Table Statement
• Renaming A Table & Columns 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

• Vertical, Horizontal, Pie
• Group, Subgroups
• Multiple Plots & Overlay
• Title and Footnote Statements
• Doughnut
• Gplot Procedure
• Symbol Statement
• Options

SAS – MACROS

• Macro Concepts
• Creating Macro Variables
• Creating a Modular Code With Macros
• Adding Parameters To Macros
• Using Various Procedure s In Macros
• Macro Functions
• Macros And Macro Variables
• Using Macro Variables
• Invoking A Macro
• Macros With Conditional Logic
• Automatic Variables
• Including External Macros

SAS – ETS

• Investment Analysis
• Types of Loans: Fixed Rate Loans, Balloon Rate Loans, ARM Loans
• Time-series Analysis
• Forecasting Analysis

Value Added

• SAS Tests
• Projects (Mini & Major)
• CV Preparation
• Certification Preparation Material