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