Practical Problem-Solving with PROC SQL

Overview
Computing a Weighted Average
Comparing Tables
Overlaying Missing Data Values
Computing Percentages within Subtotals
Counting Duplicate Rows in a Table
Expanding Hierarchical Data in a Table
Summarizing Data in Multiple Columns
Creating a Summary Report
Creating a Customized Sort Order
Conditionally Updating a Table
Updating a Table with Values from Another Table
Creating and Using Macro Variables
Using PROC SQL Tables in Other SAS Procedures
Copyright © SAS Institute Inc. All rights reserved.