PROC TABULATE by Example, Second Edition
- 4h 19m
- Julie McKnight, Lauren Haworth Lake
- SAS Institute
- 2015
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.
About the Authors
Lauren Haworth Lake, an analytics expert based in San Francisco, has over a decade of experience using SAS. She has been using the Output Delivery System since the first beta version was released in 1998. As the author of the popular SAS programming book, PROC TABULATE by Example, Lauren brings expert writing and programming skills to the second edition. Lauren is also coauthor of Output Delivery System: The Basics and Beyond.
Julie McKnight, a technical writer at SAS, has been writing Base SAS documentation since 2000. She specializes in PROC TABULATE and ODS documentation. Julie has 13 years of experience programming and reporting with SAS. Julie’s work has won several awards from the Society for Technical Communication, including an award of Distinguished Technical Communication for SAS 9.1 Output Delivery System User's Guide.
In this Book
-
Benefits of Using PROC TABULATE
-
PROC TABULATE Quick Reference
-
Before Writing PROC TABULATE Code
-
Create a One-Dimensional Table
-
Creating Two-Dimensional Tables
-
Creating Three-Dimensional Tables
-
Handling Percentages
-
Handling Complex Percentages
-
Modifying Row and Column Headings
-
Formatting Table Values
-
Using the Output Delivery System
-
Handling Missing Data
-
Using Macros to Generate Tables
-
PROC TABULATE Tricks: How to Cheat to Create Complex Tables
-
Troubleshooting Your Table
-
Decoding Error Messages
-
Incorrect Tables and How to Fix Them
-
Limitations of PROC TABULATE and How to Get around Them
-
PROC TABULATE Options Reference
-
ODS Reference
-
Recommended Reading
