Base & Advance Sas

Base & Advance Sas

Courses Info

Base advance sas training institute in delhi  We offer base and advance SAS training by well qualified IT professionals working in big mnc’s. We have experienced trainer. We provide daily basis study material, assignments.  We offer base advance sas training by most experienced trainer. We offer below syllabus for base advance sas.

base advance sas training

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

 

  • 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

 

  • 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

 

  • 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 functions