Advance SAS Syllabus

P A R T 1 SQL Processing With SAS

Chapter 1: Performing Queries Using PROC SQL

o PROC SQL Basics

o Writing a PROC SQL Step

o Selecting Columns

o Specifying the Table

o Specifying Subsetting Criteria

o Ordering Rows

o Querying Multiple Tables

o Summarizing Groups of Data

o Creating Output Tables

Chapter 2: Performing Advanced Queries Using PROC SQL

o Viewing SELECT Statement Syntax

o Displaying All Columns

o Limiting the Number of Rows Displayed

o Eliminating Duplicate Rows from Output

o Subsetting Rows by Using Conditional Operators

o Subsetting Rows by Using Calculated Values

o Enhancing Query Output

o Summarizing and Grouping Data

o Subsetting Data by Using Subqueries

o Subsetting Data by Using Noncorrelated Subqueries

o Subsetting Data by Using Correlated Subqueries

Chapter 3: Combining Tables Horizontally Using PROC SQL

o Understanding Joins

o Generating a Cartesian Product

o Using Inner Joins

o Using Outer Joins

o Creating an Inner Join with Outer Join-Style Syntax

o Comparing SQL Joins and DATA Step Match-Merges

o Using In-Line Views

o Joining Multiple Tables and Views

Chapter 4: Combining Tables Vertically Using PROC SQL

o Understanding Set Operations

o Using the EXCEPT Set Operator

o Using the INTERSECT Set Operator

o Using the UNION Set Operator

o Using the OUTER UNION Set Operator

o Comparing Outer Unions and Other SAS Techniques

Chapter 5: Creating and Managing Tables Using PROC SQL

o Understanding Methods of Creating Tables

o Creating an Empty Table by Defining Columns

o Displaying the Structure of a Table

o Creating an Empty Table That Is Like Another Table

o Creating a Table from a Query Result

o Inserting Rows of Data into a Table

o Creating a Table That Has Integrity Constraints

o Handling Errors in Row Insertions

o Displaying Integrity Constraints for a Table

o Updating Values in Existing Table Rows

o Deleting Rows in a Table

o Altering Columns in a Table

o Dropping Tables

Chapter 6: Creating and Managing Indexes Using PROC SQL

o Understanding Indexes

o Deciding Whether to Create an Index

o Creating an Index

o Displaying Index Specifications

o Managing Index Usage

o Dropping Indexes

Chapter 7: Creating and Managing Views Using PROC SQL

o Creating and Using PROC SQL Views

o Displaying the Definition for a PROC SQL View

o Managing PROC SQL Views

o Updating PROC SQL Views

o Dropping PROC SQL Views

Chapter 8: Managing Processing Using PROC SQL

o Specifying SQL Options

o Controlling Execution

o Controlling Output

o Testing and Evaluating Performance

o Resetting Options

o Using Dictionary Tables

P A R T 2 SAS Macro Language

Chapter 9: Introducing Macro Variables

o Basic Concepts

o Using Automatic Macro Variables

o Using User-Defined Macro Variables

o Processing Macro Variables

o Displaying Macro Variable Values in the SAS Log

o Using Macro Functions to Mask Special Characters

o Using Macro Functions to Manipulate Character Strings

o Using SAS Functions with Macro Variables

o Combining Macro Variable References with Text

Chapter 10: Processing Macro Variables at Execution Time

o Creating a Macro Variable During DATA Step Execution

o Creating Multiple Macro Variables During DATA Step Execution

o Referencing Macro Variables Indirectly

o Obtaining Macro Variable Values During DATA Step Execution

o Creating Macro Variables During PROC SQL Step Execution

o Working with PROC SQL Views

o Using Macro Variables in SCL Programs

Chapter 11: Creating and Using Macro Programs

o Basic Concepts

o Developing and Debugging Macros

o Using Macro Parameters

o Understanding Symbol Tables

o Processing Statements Conditionally

o Processing Statements Iteratively

o Using Arithmetic and Logical Expressions

Chapter 12: Storing Macro Programs

o Understanding Session-Compiled Macros

o Storing Macro Definitions in External Files

o Storing Macro Definitions in Catalog SOURCE Entries

o Using the Autocall Facility

o Using Stored Compiled Macros