Courses Info
  • 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