One Of the Best Analytics Training Institute In Gurgaon and Delhi NCR

Courses Info

CST Analytics is an instructor drove SAS analytics training institute in Delhi ncr, which offers proficient SAS courses to apprentices, propelled programmers and experts, who wish to enhance their insight into SAS. We are one of the biggest endeavors devoted towards offering the best SAS training both in India and in the web space.

At analytics training institute in Delhi ncr we have been bestowing top notch training in the most ultra-modern Analytics devices and procedures to experts trying to build a high development Analytics career.

Our SAS courses welcome programmers from all aspects of the globe and offer in-depth examining programs for any level of difficulty. Our qualified mentors have every single necessary skills and learning to teach you all that you have to know in order to work in SAS, from basics to the intricate analytics training.

Our analytics training institute’s vision is to empower as many people as could possible on the planet to figure out how to settle on choices better and quicker. We trust this should be possible with the assistance of Analytics and our suite of courses helps individuals over the globe to do only that. Our philosophy is to make practical and consistent way to deal with learning Analytics. Our courses are industry relevant and are periodically updated to stay aware of changes in technology and methodology in the quickly developing Analytics space.

Institute’s vision is to empower as many people as could possible on the planet to figure out how to settle on choices better and quicker. We trust this should be possible with the assistance of Analytics and our suite of courses helps individuals over the globe to do only that. Our philosophy is to make practical and consistent way to deal with learning Analytics. Our courses are industry relevant and are periodically updated to stay aware of changes in technology and methodology in the quickly developing Analytics space.

analytics training institute in ncr

Syllabus of Analytics Training Course

INTRODUCTION TO SAS PROGRAMMING

  • Working in the SAS Environment
  • Working with the Windows
  • Enhance Editor
  • Result Window
  • Log Window
  • Explorer Window
  • Output Window
  • Program Editor Window

BASICS OF SAS LANGUAGE

  • SAS Libraries
  • Data Sets
  • Cube
  • Data View
  • Referencing Files in Catalog
  • Creating a SAS Program
  • Components of SAS Program
  • Characteristics of SAS Program
  • Layout of 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 step

CREATING SAS DATA SETS

  • Create temporary and permanent SAS data sets
  • Create and manipulate SAS date values
  • Control which observations and variables in a SAS data set are processed and output

DATA STEP PROCESSING

  • Program Data Vector (PDV)
  • Execution Phase and Compilation Phase
  • Get Started with Output Delivery System ( ODS )

STATEMENT OPTIONS

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

MANAGING 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

COMBINING SAS DATA SETS

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

CONDITIONAL STATEMENTS

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

WRITING DATA TO EXTERNAL FILES

  • File Statement
  • Put Statement

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 & 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 Contents
  • Proc Formats, Proc Compare
  • Proc Append, Proc Tabulate
  • Proc Report
  • Proc Import, Proc Export
  • Proc Freq
  • Proc Means

SAS ADVANCE TRAINING SYLLABUS

ADVANCE SAS TRAINING SYLLABUS

  • Introduction to SAS Macro Language Elements
  • Introduction to Macro Variables
  • Automatic Macro Variables
  • User define Macro Variables
  • How Macro processing will undergo inside the SAS system
  • Macro Statements
  • Macro Functions
  • Autocall Macros

SAS MACROS

  • SAS Libraries
  • Introduction to SAS Macro Language Elements
  • Introduction to Macro Variables
  • Automatic Macro Variables
  • User define Macro Variables
  • How Macro processing will undergo inside the SAS system
  • Macro Statements
  • Macro Functions
  • Autocall Macros

ACCESSING DATA USING SQL

  • Introduction to Proc SQL
  • Generate detail reports by working with a single table or joining tables using PROC SQL
  • Generate summary reports by working with a single table or joining tables using PROC SQL
  • Inserting data into Tables
  • Alter & update the tables
  • Construct sub queries within a PROC SQL step
  • SQL pass through Facility
  • Connecting to DBMS
  • Natural Joins
  • Inner Joins
  • Outer Joins
  • Access Dictionary Tables using the SQL procedure
  • Work with indexes using the macro interface/creating macro variables with SQL, defining integrity constraints

SAS DI STUDIO (Data Integration Studio)

  • Exploring SAS Data Integration Studio
  • Working on Change Management
  • Explaining how to define source, target data structures and designing jobs.
  • Introduction to jobs and the job editor
  • Working with propagation and mappings
  • working with intermediate files
  • working with the extract transformation
  • working with summary statistics transformation
  • explore status handling for transformations and jobs
  • working with the data validation transformation
  • working with the sort transformation
  • working with the append transformation
  • working with the transpose transformation
  • working with the apply lookup standardization transformation
  • iterating a job with Loop transformations
  • basics of the Table Loader transformation
  • load styles of the Table Loader transformation
  • table properties and load techniques of the Table Loader transformation
  • Defining slowly changing dimensions
  • Using the SCD type 2 Loader and Change Data capture transformations (Pre & Post Process).
  • analyzing metadata using impact analysis