Welcome to Sas India Trainings

Courses

  • Home
  • Advance SAS Training
SAS Training
Analytics Training
Big Data

SAS BASE TRAINING SYLLABUS

Get Access
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
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
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
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
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
MANAGING DATA
  • 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
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
Get Access

image
image
image
image
image

Legal disclaimer: The phrase "SAS" or "language of SAS" or “SAS language” or "SAS programming language" used in this web site is used to describe the computer language commonly called "the SAS language" The phrase "SAS program" or "SAS code" or "SAS script" used in this website is used to describe programs, codes, scripts and applications written in the language of SAS. It does not refer to software owned and sold by the SAS Institute. The phrase "SAS" or "SAS programming language" does not refer to the software owned and sold by the SAS Institute. Whenever referring to the software owned and sold by the SAS Institute, the phrases “SAS® Software” or “by SAS Institute®” are mentioned.
Non-Associations: SAS India Trainings is not associated in any way with SAS Institute Inc SAS India Trainings does not conduct any training on the paid versions of SAS® Software from the SAS Institute Inc.

*Note: Hard copy of the certificate can be delivered at a price of ₹ 300.