SAS (Base & Advance)

Current Status
Not Enrolled
Price
300
Get Started

Course Description

This is a power-packed program for SAS certification aspirants and the most sure-shot way to prepare Base SAS Global Certification.

Key concepts covered include:

SAS BASE TRAINING SYLLABUS

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

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

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 Progra

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

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

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

MACRO PROCESSING

  • Creating and using user-defined and automatic macro variables within the SAS Macro Language
  • Automating programs by defining and calling macros using the SAS Macro Language
  • Various system options available for macro debugging
  • Displaying values of user-defined and automatic macro variables in SAS log
  • Understand the use and implantation of macro function

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

Who Should do this course ?

Candidates from various quantitative backgrounds, like Engineering, Finance, Maths, Statistics, Business Management who want to develop hands-on SAS skills and clear the Base SAS certification exam.

Course Duration

40 hours

Classes

12

Tools

SAS

Learning Mode

Live/Video Based

Fees

26,499

NOTE: FEE IS NON - REFUNDABLE