Certification in SAS Programme

 Comprehensive curriculum on Data Analytics, Base SAS & Advanced SAS

 Hands-on learning through Case Studies, Data Sets and Live Project Work

 100% Career Assistance – Resume Building and Interview Prep

 100% Clear Two International SAS Certifications

+91- 8510 827 111 / 222 / 888

info@headstartechnologies.com

Register Now!

Some words about Headstar Technologies

What we do?

Headstar Technologies is the leading learning solutions and professional services provider in India. Headstar Technologies is focused on meeting the growing need for Information and Communication Technology (ICT) expertise in both global and local markets. Providing its clients with IT Training, Corporate Training, Software development, Web Development and Consultancy Services. Headstar Technologies enables its clients to accelerate their business growth through more effective use of ICT in their respective industry.It is the best IBM BP.

Course Objectives

This course, developed specifically for the business analyst will teach how to capture structured, semi-structured and unstructured data from several different data source types using IBM InfoSphere BigInsights and then do manipulations and analysis on the gathered data. This course will focus on using the Graphical User Interface of InfoSphere BigInsights to collect, manipulate, analyze, view and export data.

About the Technology

IBM® InfoSphere® BigInsights™ is an analytics platform, based on open source Apache H doop, for analyzing massive volumes of unconventional data in its native format. The software enables advanced analysis and modeling of diverse data, and supports structured, semi-structured and unstructured content to provide maximum flexibility.

Do you want to get more info about us?Find Out More

Our SAS Training

LIVE PROJECT TRAINING

This SAS training course will help you in understanding the spaces of business examination and business intelligence. Endless supply of this SAS Training you will have enough capability in perusing spreadsheets, databases, use SAS functions for manipulating this data and debugging it. This training also includes data mining, modeling techniques, visualization of data, predictive analysis and extracting insights.

  • Learn the SAS environment and various windows
  • Comprehend the SAS Enterprise Guide
  • Study the logical statements, administrators and capacities
  • Create data sets and deploy Compilation and Execution
  • Understand SAS graphs and summary reports
  • Become more acquainted with Advanced SAS and Base SAS
  • Be set up for BASE SAS Professional Certification
  • Business Intelligence experts
  • Software developers and architects
  • Project managers
  • ETL, SQL, data warehouse and analytics professionals
  • Mainframe and testing professionals
  • Graduates wanting to enter Big Data analytics

Anybody can learn SAS and get trained. Having a basic knowledge of SQL can help

SAS is an intense business examination apparatus that is utilized by endeavors to enhance their business execution. This SAS preparing gives all of you the correct abilities to work with spreadsheets, immense measured databases and systems for troubleshooting. In this manner with the SAS Programming Certification you can apply for employments in high development organizations that are looking for SAS experts for enhancing the speed of their basic leadership.

  • 70% of organizations say investigation is vital to how they decide – IBM Study
  • Most companies estimate they’re analyzing a mere 12% of the data they have – Forrester Research

Our awesome features

Audience

MBA & Engineering – Faculty members.

Pre-requisites

Data analysis skills or equivalent knowledge.

Course Materials provided

Student Manual
Course ware in PDF format
Slide Deck (presentation format)

Assignment

This course includes Demos, and Tasks as exercises for participants. Case Studies and success stories are provided to help participants with better insight to business application.

Lab Setup Guide

Lab setup Guide is provided detailing the system pre-requisites, installation guidelines and details of setups to be followed for configuration requirement (if any)

Course Completion & Certification

On successful completion of the course participants will be provided with training completion certificate.

Our Curriculum

BASE SAS INTRODUCTION

  • An Overview of the SAS System
  • SAS Tasks
  • Output produced by the SAS System
  • SAS Tools (SAS Program – Data step and Proc step)
  • A sample SAS program
  • Exploring SAS Windowing Environment Navigation

DATA ACCESS & DATA MANAGEMENT

  • SAS Data Libraries
  • Rules for Writing SAS Programs / Statements, Dataset Variable Name Getting familiar with SAS Dataset
  • Data portion of the SAS Dataset
  • Rules for writing Dataset names / Variable names
  • Attributes of a Variable (Numeric / Character)
  • Options
  • System Options (nodate, linesize, pagesize, pagenoetc)
  • Dataset Options (Drop, Keep, Rename, Where, Firstobs= Obs=)
  • How SAS works (Flow of Data Step Processing – Compilation & Execution phase)
  • Input Buffer
  • Program data vector (PDV)
  • Descriptor Information of a SAS Dataset

DATALINES OR CARDS DATA TRANSFORMATIONS

  • SAS Date Values
  • Length Statement
  • Creating multiple output SAS datasets from singe input SAS dataset
  • Conditionally writing observations to one or more SAS datasets
  • Outputting Multiple Observations (Implicit Output)
  • Selecting Variables and observations (DROP or KEEP statement and DROP= or KEEP = dataset options)
  • Controlling which Observations are read (OBS= FIRSTOBS = Options)
  • The Data Statement_Null_
  • The_N_Automatic Variable
  • Creating Subset of observations
  • Conditional Processing using IF-THEN and ELSE statement, IF—-THEN DO ; —-END;ELSE DO;—-END;DO WHILE Statement
  • DO UNTIL Statement
  • Iterative DO loop Processing
  • Where Statement OR Where Condition (dataset)
  • Deciding whether to use a Where statement or Subsetting IF statement
  • Accumulating Totals for a Group of Data (BY- Group Processing (First & Last)
  • Multiple BY variables
  • DATASETS Procedure ( To modify the Variable name/lable/format/informat)
  • Reading SAS datasets and Creating Variables
  • Creating an Accumulating Variable (The RETAIN Statement)
  • The DELETE Statement
  • The SUM Statement
  • The RENAME = Data Set option
  • Combining SAS Datasets
  • Concatenating SAS Data Sets Using SET statement in DATA Step
  • Inter Leaving SAS Data Sets
  • Merging SAS Data Sets
  • Match-Merge
  • Using Merge Statement
  • THE IN = Data Set option
  • Additional Features of merging SAS Datasets
  • One-to-Many Merging
  • Many-to-Many Merging

READING RAW DATA FROM EXTERNAL FILE ( INFILE& INPUT STATEMENT )

  • Introduction to Raw Data
  • Factors considered to examine the raw data
  • Reading Unaligned Data (List Input)
  • Reading Data Aligned to Columns (Column Input)
  • Reading Data that requires Special Instructions (Formatted Input)
  • Controlling the position of the Pointer in Formatted Input
  • Absolute – Column pointer control (@)
  • Relative- Column pointer control (+)
  • Mixed Style Input ( Mixing List, Input. Formatted Input styles in one INPUT Staement)
  • Using colon (:) modifier to specify an informat in the INPUT Statement )
  • Recognize delimiter in the raw data file (Using DLM= option in INFILE Statement
  • Missing data at the end of row (Using MISSOVER option in INFILE statement )
  • Missing values without placeholders (DSD option in INFILE statement)
  • Reading a raw data file with multiple records per observation(Column pointer controls)
  • Method1: Using Multiple INPUT statement
  • Method2: Using Line Pointer Control (/)
  • Reading Variables from multiple records in any order (#n)
  • Line Hold Specifies in INPUT statement
  • The Single Trailing @
  • The Double Trailing @@ ( Multiple Observations per Record)
  • Methods of Control in INFILE statement
  • FLOWOVER
  • STOPOVER
  • MISSOVER
  • TRUNCOVER
  • Writing to an External File (FILE & PUT Statement )
  • Reading Excel Spreadsheets (IMPORT Wizard / Import Procedure)

SAS FUNCTIONS

  • Manipulating Character Values (SUBSTRING / RIGHT / LEFT / SCAN/ CONCATENATION TRIM / FIND / INDEX / UPCASE / LOWCASE / COMPRESS / LENGTH )
  • Manipulation Numeric Values ( ROUND / CEIL / FLOOR / INT / SUM / MEAN /MIN/MAX)
  • Manipulating Numeric Values based on DATES ( MDY / TODAY / INTCK / YRDIF)
  • Converting Variable Type
  • INPUT ( character-to-numeric)
  • PUT (numeric-to-character)
  • Debugging SAS program (DEBUG Option)
  • SAS VARIABLE Lists
  • SAS Arrays
  • Enhancing Report Output
  • Defining Titles & Footnotes
  • Formatting Data values ( Date, Character & Numeric values )
  • Creating User-Defined Formats (Proc Format)
  • Formats &Informats

ANALYSIS & PRESENTATION

  • Descriptor portion of the SAS Data Set ( Proc Contents)
  • Producing List Reports (Proc Print)
  • Sequencing and Grouping Observations (Proc Sort)
  • Producing Summary Reports
  • PROC FREQ -(One Way & Two-Way Frequencies)
  • PROC MEANS
  • PROC REPORT
  • PROC TABULATE
  • PROC SUMMARY
  • PROC PRINTO
  • PROC APPEND
  • PROC TRANSPOSE
  • PROC COPY
  • PROC COMPARE
  • PROC DATASETS
  • Regression Procedure
  • Univariate / Multivariate Procedures
  • Ranking Procedure
  • Producing Bard and Pie Charts
  • Producing Plots
  • The Output Delivery System (SAS/ODS)
  • Creating HTML Reports
  • Creating Text Reports
  • Creating PDF Reports
  • Creating CSV Files

SAS MACRO LANGUAGE INTRODUCTION TO THE MACRO FACILITY PURPOSE OF THE MACRO FACILITY

  • Generate SAS code using Macros (%Macro & %Mend)
  • Tips on Writing Macro-Based Programs
  • Replacing Text Strings using Macros Variables (%Let)

MACRO PROGRAMS

  • MACRO PROGRAMS
  • Defining a Macro (%Macro & %Mend )
  • Macro Compilation
  • Monitoring Macro Compilation (MCOMPILENOTE OPTION)
  • Calling a Macro (%Macro-Name)
  • Macro Execution
  • Monitoring Macro Execution (MLOGIC OPTION)
  • Viewing the generate SAS Code in the Log from Macro Program (MPRINT OPTION)
  • Macro Storage
  • Macro Parameters
  • Macro Parameters Lists
  • Macros with Positional Parameters
  • Macros with Keyword Parameters
  • Arithmetic and logical Operations
  • Conditional Processing
  • % IF expression % THEN text ; %ELSE %TEXT;
  • % IF expression % THEN %DO; %END; %ELSE; %DO;
  • Stored Compiled Macros
  • %INCLUDE Statement

 

MACRO PROCESSING

  • Tokens
  • Macro Triggers
  • How the Macroprocessor works

MACRO VARIABLES CONCEPTS

  • Referencing a Macro Variable
  • Displaying Macro Variable Value in the SAS log (SYMBOLGEN OPTION)
  • Automatic Macro Variables
  • System-Defined Macro Variables (_AUTOMATIC_)
  • User-Defined Macro Variable (_USER_)
  • Datatype
  • %LET Statement
  • Global Macro variables
  • Local Macro Variables
  • Deleting User-Defined Macro Variable (%SYMDEL)
  • Macro Functions
  • Character Strings
  • Other SAS Functions
  • %SYSFUNC
  • %STR
  • Combining Macro Variable References with Text
  • Macro Variable Name Delimiter
  • Quoting
  • Creating Macro Variables in the Data Step (CALL SYMPUT ROUTINE) Obtaining Variable value during Macro Execution (SYMGET FUNCTION)Creating Macro Variables during PROC SQL Execution (INTO Clause)
  • Creating a delimited list of Values.

SAS SQL PROCESSING INTRODUCTION TO THE SQL PROCEDURE SET OPERATORS

  • Terminology
  • Features of PROC SQL
  • PROC SQL Syntax (SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY)
  • VALIDATE Keyword
  • NOEXEC Option
  • Added PROC SQL Statements (ALTER, CREATE, DELETE, DESCRIBE, DROP)
  • FEEDBACK OPTION
  • PROC SQL and DATA Step Comparisons
  • Queries
  • Retrieving Data from a table
  • Identify All Rows in a Table
  • Remove Duplicate Rows
  • Sub setting using WHERE clause
  • Sub setting with Calculated Values
  • Sub setting with Calculated Values
  • Enhancing Query Output (LABEL, FORMAT)
  • Grouping Data (Group By)
  • Analyzing Groups of data (COUNT)
  • Updating Data values (Update Statement)
  • Using Table Alias
  • Creating Views
  • Creating Dropping Indexes
  • Sub Queries
  • Non-Correlated Sub Query
  • Correlated Sub Query
  • Combining Tables
  • Joins
  • Inner Joins
  • Outer Joins
  • Left Join
  • Right Join

What People Are Saying About Headstar technologies

Meet our happy clients and find why our Agency is the preferred choice.

  • There is highly qualified and experienced faculty. The training is done on SAS Training. The overall training is good. The services provided are also good. And it is an happy experience here.

    Chirag Patel

  • I have been learning SAS Training for about 3 weeks. He puts a lot of effort in practical sessions and assignments which helps a lot in understanding the fundamentals of SAS. So far the experience with ibm has been good.

    Sumit Balhara

  • The faculty and management is quite good. SAS learning seems quite easy.

    Prashant Mani

  • He facilities and teaching are quite good. I can understand SAS in a very easy way.

    Shilpi Rani

Get More information about SAS Programme

Find Out How I Can Help You

Make faster & better decisions. Fill out the form below, and my assistant will arrange a time for you and me to have a call about growing your business.

Rajendra Place Near Metro Station Gate No-2, New Delhi &

C-43, Sector-2,Noida, U.P

+91- 8510827111/222/888

info@headstartechnologies.com