PROC SQL by Example: Using SQL within SAS

SAS Code

• Chapter 2: Basic Building Blocks
• Chapter 3: More Building Blocks
• Chapter 4: Joins
• Chapter 5: Subqueries
• Chapter 6: Set Operators
• Chapter 7: Global Statements, Options, and Session Management
• Chapter 8: Using the Macro Facility with PROC SQL
• Chapter 9: Table Maintenance and Alternate Strategies
• Chapter 10: Views
• Chapter 11: PROC SQL as a Report Generator
• Chapter 12: Mixed Solutions
• Chapter 13: Performance Tuning
• Chapter 14: Documentation Roadmap
• Appendix A: SASHELP.CLASS Data Set

• Chapter 2: Basic Building Blocks
• 2.1: The Simplest SELECT Statement
• 2.2: A More Selective SELECT
• 2.3: Storing Results
• 2.4: Column Subsets
• 2.5: New Columns
• 2.6: Aggregation
• 2.7: Conditionality
• 2.8: Filtering
• 2.9: Reordering Rows
• 2.10: Elimination of Duplicates
• Chapter 3: More Building Blocks
• 3.1: Combining Summary Statistics with Original Detail
• 3.2: Summary Statistics Based on Distinct Values
• 3.3: Preprocessing the Source with Inline Views
• Chapter 4: Joins
• 4.1: Avoiding Ambiguity in Column References
• 4.2: The Simplest Merges and Joins
• 4.3: Matching with Nonrepeating Keys
• 4.4: Matching with Repeating Keys
• 4.5: More about Joins and Merges
• 4.6: More about Joins
• Chapter 5: Subqueries
• 5.1: Contexts That Expect Subqueries
• 5.2: General Usage of Subqueries
• Chapter 6: Set Operators
• 6.1: The Contrast between Joins and Set Operators
• 6.2: Set Operators: Preview
• 6.3: Concatenation and Interleaving with OUTER UNION
• 6.4: Data Type Compatibility
• 6.6: UNION
• 6.7: INTERSECT
• 6.8: EXCEPT
• Chapter 7: Global Statements, Options, and Session Management
• 7.1: Global Statements
• 7.2: PROC SQL Options
• Chapter 8: Using the Macro Facility with PROC SQL
• 8.1: Generating PROC SQL Code
• 8.2: Populating Macro Variables
• Chapter 9: Table Maintenance and Alternate Strategies
• 9.1: Environment for Examples
• 9.2: Distinguishing Persistence from Replacement
• 9.4: Data Maintenance
• 9.5: Metadata Maintenance
• 9.6: Changing Structure
• 9.7: Changing Features
• Chapter 10: Views
• 10.1: Defining Views
• 10.2: Using Views
• 10.3: Inspecting Views
• 10.4: Changing a Table via a View
• 10.5: Managing Library References
• Chapter 11: PROC SQL as a Report Generator
• 11.1: Simple Reports
• 11.2: Complex Reports
• 11.3: Reports with Long Character Strings
• 11.4: PROC SQL and the Output Delivery System
• Chapter 12: Mixed Solutions
• 12.1: Example: Schedule Matrix
• 12.2: Example: Identifying Spikes in a Series
• 12.3: Example: Using PROC TRANSPOSE to Normalize
• Chapter 13: Performance Tuning
• 13.1: Resource Example: The Effect of an Index
• 13.2: Code Example: The Advantage of Equijoins
• Chapter 14: Documentation Roadmap
• 14.3: The Three Expressions Revisited
• 14.4: Could It Be More Logical?
• Appendix A: SASHELP.CLASS Data Set

This material is provided "as is" by SAS Institute Inc. There are no warranties, expressed or implied, as to merchantability or fitness for a particular purpose regarding the materials or code contained herein. The Institute is not responsible for errors in this material as it now exists or will exist, nor does the Institute provide technical support for it.

Questions or problem reports concerning this material may be left at the book's sasCommunity.org wiki page or sent via the author's sasCommunity.org e-mail. Or, contact the author c/o:

If you prefer, you can send email c/o SAS. Address to saspress@sas.com and use "Comments for Howard Schreier" as the subject.