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 Sub setting 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 Sub setting Rows by Using Conditional Operators
o Sub setting Rows by Using Calculated Values
o Enhancing Query Output
o Summarizing and Grouping Data
o Sub setting Data by Using Sub queries
o Sub setting Data by Using No correlated Sub queries
o Sub setting Data by Using Correlated Sub queries
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 Catalogue SOURCE Entries
o Using the Auto call Facility
o Using Stored Compiled Macros