PROC TABULATE by Example, 2nd Edition

An abundance of real-world examples highlights Lauren Haworth Lake’s and Julie McKnight’s PROC TABULATE by Example, Second Edition. Beginning and intermediate SAS® users will find this step-by-step guide to producing tables and reports using the TABULATE procedure both convenient and inviting.

Topics are presented in order of increasing complexity, making this an excellent training manual or self-tutorial. The concise format also makes this a quick reference guide for specific applications for more advanced users. A very handy section on common problems and their solutions is also included.

With this book, you will quickly learn how to generate tables using macros, handle percentages and missing data, modify row and column headings, and produce one-, two-, and three-dimensional tables using PROC TABULATE. Also provided are more advanced tips on complex formatting with the Output Delivery System (ODS) and exporting PROC TABULATE output to other applications.

Table of Contents

Part 1. Introduction
Chapter 1. Benefits of Using PROC TABULATE
Chapter 2. PROC TABULATE Quick Reference
Chapter 3. Before Writing PROC TABULATE Code

Part 2. The Basics
Chapter 4. Create a One-Dimensional Table
Chapter 5. Creating Two-Dimensional Tables
Chapter 6. Creating Three-Dimensional Tables

Part 3. Intermediate Topics
Chapter 7. Handling Percentages
Chapter 8. Handling Complex Percentages
Chapter 9. Modifying Row and Column Headings
Chapter 10. Formatting Table Values
Chapter 11. Using the Output Delivery System
Chapter 12. Handling Missing Data

Part 4. Advanced Topics
Chapter 13. Using Macros to Generate Tables
Chapter 14. PROC TABULATE Tricks: How to Cheat to Create Complex Tables

Part 5. Common Errors
Chapter 15. Troubleshooting Your Table
Chapter 16. Decoding Error Messages
Chapter 17. Incorrect Tables and How to Fix Them
Chapter 18. Limitations of PROC TABULATE and How to Get around Them

Part 6. Special Topics
Chapter 19. PROC TABULATE Options Reference
Chapter 20. ODS Reference

Part 7. Appendix
Chapter 21. PROC TABULATE Syntax