SAS CERTIFICATION

Duration : 1 Years

Course Fee: ₹ INR 5000 To 500000 INR Approx /-
Eligibility: Have passed 10+2 in any stream from a recognized board

About SAS CERTIFICATION

SAS Certification

Statistical Analysis Software (SAS) is programming created by the SAS Institute and is presently being used by around 118 countries to solve complex business issues.

SAS Certification got started in North Carolina State University for dissecting the agriculture research. With the accomplishment of the system, it got officially launched in 1976 for the use in huge drug organizations, banks and government bodies. Nowadays, it is viewed as the best system for information management and factual examination or analysis.

SAS Certification Eligibility

For doing SAS Certification program you have to bachelor’s / Master’s degree with 60% marks in aggregate in B.Pharm, M.Pharm, Pharm D, Bio-Technology, MBBS, MD, BDS, BHMS, BUMS, BAMS, BPT/ M.Sc, etc.

SAS Certification Course Syllabus

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

Oh No!! You're Missing The (FREE) Career Guidance

Name ^*

Email ^*

Phone ^*

City^*

Courses^*

Airtel	Infosys
Vodafone	Crisil
SBI Life Insurance	Sun Pharmaceuticals Industries Limited
Cognizant	TATA Consultancy Services
Wipro	IKon Staffing Solutions Pvt. Ltd.
Reliance Communications

More to Explore

More to Explore