PROC SQL By Example

Using SQL Within SAS

Author: Howard Schreier

Publisher: SAS Press

Examples of the components of SQL for use in SAS.

Editions

Paperback (2008)

Paperback

Year: 2008

ISBN: 978-1-59994-297-1

Pages: 291

Publisher’s list price: 39.95

Contents

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