PROC TABULATE by Example, Second Edition

Table of contents

1. Title Page
2. Copyright
3. About This Book
4. About the Author
5. Acknowledgments
6. 1. Chapter 1: Benefits of Using PROC TABULATE
      1. Introduction
      2. Example without Using PROC TABULATE
      3. Example Using PROC TABULATE
   2. Chapter 2: PROC TABULATE Quick Reference
      1. Introduction
      2. One–Dimensional Table
      3. Two–Dimensional Tables
      4. Three–Dimensional Tables
      5. The Output Delivery System (ODS) and PROC TABULATE
   3. Chapter 3: Before Writing PROC TABULATE Code
      1. Introduction
      2. Sketch a Rough Draft of the Table
      3. Examine the Data
      4. Plan the Categories
      5. Select the Statistics
      6. Create a Detailed Sketch of the Table
7. 1. Chapter 4: Create a One-Dimensional Table
      1. Introduction
      2. The Sketch
      3. Terms to Know
      4. Make the Simplest Table Possible
      5. Add Statistics
      6. Add a Class Variable
      7. Put It All Together
      8. Quick Tips
   2. Chapter 5: Creating Two-Dimensional Tables
      1. Introduction
      2. The Sketch
      3. Terms to Know
      4. Turn a One-Dimensional Table into a Two-Dimensional Table
      5. Statistic Definitions for a Two-Dimensional Table
      6. Add Class Variables on Both Dimensions
      7. Add Another Class Variable
      8. Nest the Class Variables
      9. Add Statistics to the Nested Variables
      10. Add Totals to Rows and Columns
      11. Add Subtotals
      12. Put It All Together
      13. Quick Tips
   3. Chapter 6: Creating Three-Dimensional Tables
      1. Introduction
      2. The Sketch
      3. Terms to Know
      4. Build the Two-Dimensional Table
      5. Add a Third Dimension
      6. Comparison to Using a BY Statement
      7. Add a Page for the Totals
      8. Put a Title in Each Table
      9. Put It All Together
      10. Quick Tips
8. 1. Chapter 7: Handling Percentages
      1. Overview
      2. The Sketch
      3. Create Cell Percentages with the PCTN Statistic
      4. Create Cell Percentages with the PCTSUM Statistic
      5. Calculate Row and Column Percentages
      6. Add Row Totals to a Table with Row Percentages
      7. Add Column Totals to a Table with Column Percentages
      8. Quick Tips
   2. Chapter 8: Handling Complex Percentages
      1. Overview
      2. The Sketch
      3. Percentages for Multiple Row Variables
      4. Percentages for Multiple Column Variables
      5. Select the Right Denominator
      6. Percentages Combined with Other Statistics
      7. Percentages with Subtotals
      8. Percentage Subtotals on Both Dimensions
      9. Percentages for Three-Dimensional Tables
      10. Percentages for Analysis Variables
      11. Quick Tips
   3. Chapter 9: Modifying Row and Column Headings
      1. Introduction
      2. The Sketch
      3. Modify Variable Labels
      4. Modify Statistic Labels
      5. Dealing with Numerous Labels
      6. Modify Row Headings
      7. Order the Headings
      8. Reordering the Headings
      9. Reorder Class Variables
      10. Modify Headings with Inline Formatting
      11. Quick Tips
   4. Chapter 10: Formatting Table Values
      1. Introduction
      2. The Sketch
      3. Use Appropriate Formats for Statistics
      4. Use Appropriate Formats for Analysis Variables and Statistics
      5. Format Percentages
      6. Format Large Numbers
      7. Weight the Results I
      8. Weight the Results II
      9. Quick Tips
   5. Chapter 11: Using the Output Delivery System
      1. Introduction
      2. Terms to Know
      3. Create Printable Output
      4. Export Tables to a Spreadsheet
      5. Customize the Appearance of Destination Output
      6. Customize the Appearance of Selected Parts of the Output with Style Overrides
      7. Create a Custom Style Template
      8. Quick Tips
   6. Chapter 12: Handling Missing Data
      1. Overview
      2. The Sketch
      3. Report the Missing Data for Class Variables with the MISSING Option
      4. Report the Missing Data for Analysis Variables with the NMISS Statistic
      5. Customize the Way Missing Data Looks in Your Table
      6. Three-Dimensional Tables with Missing Data
      7. Break Up the Table
      8. Display Variable Categories That Have Missing Data
      9. Exclude Missing Data
      10. Quick Tips
9. 1. Chapter 13: Using Macros to Generate Tables
      1. Introduction
      2. Repeat a Table for a Series of Class Variables
      3. Repeat a Table for a Series of Statistics
      4. Repeat a Table for Various Time Periods - I
      5. Repeat a Table for a Series of Time Periods - II
      6. Create a Generic Macro to Produce Tables
   2. Chapter 14: PROC TABULATE Tricks: How to Cheat to Create Complex Tables
      1. Introduction
      2. Match the Table Design to Predefined Specifications
      3. Rename the Statistics and Variables
      4. Calculate Percentages Another Way
      5. Display the Results of Multiple-Response Questions
      6. Use a Variable for Both Classification and Analysis
      7. Create a One-Dimensional Table That Runs Vertically
      8. Handle ClassVariables with Missing Data
      9. Create Footnote References in Table Cells - I
      10. Create Footnote References in Table Cells - II
      11. Use the CLASSDATA Option
10. 1. Chapter 15: Troubleshooting Your Table
       1. Introduction
       2. What to Try First
       3. Break Your Problem Down Step-By-Step
       4. Bring in Expert Assistance
    2. Chapter 16: Decoding Error Messages
       1. Introduction
       2. "Type of Name Is Unknown"
       3. "Statistic Other Than N Was Requested without Analysis Variable"
       4. "Multiple Statistics Associated with a Single Table Cell"
       5. "Multiple Analysis Variables Associated with a Single Table Cell"
       6. "Class Variable Is Missing on Every Observation"
       7. "PCTN Base Is Not in Table" and "PCTN Crossing Has No Denominator"
    3. Chapter 17: Incorrect Tables and How to Fix Them
       1. Introduction
       2. Number of Observations Seems Too Small
       3. Some of the Values of the Class Variable Are Not Shown
       4. A Format Is Not Being Applied to a Variable
       5. Blank Label Is Not Being Applied to a Variable
       6. A Statistic’s Label Is Blank, but a Space Is Left in the Row Label
       7. Statistics Labels Do Not Appear Next to the Correct Variable
       8. Incorrectly Grouped Statistics
       9. Alternative to Using the FUZZ Option
    4. Chapter 18: Limitations of PROC TABULATE and How to Get around Them
       1. Introduction
       2. Advanced Statistical Tests
       3. Printing Record Details
       4. Formatting Text Values
11. 1. Chapter 19: PROC TABULATE Options Reference
       1. Introduction
       2. CLASS Statement Options
       3. CLASSLEV Statement
       4. KEYWORD Statement
       5. PROC TABULATE Statement
       6. TABLE Statement
       7. VAR Statement
       8. System Options That Affect PROC TABULATE Output
       9. Recommended SAS 9 Option Settings
       10. Quantile Statistics Examples
       11. Create Ouput Data Sets
    2. Chapter 20: ODS Reference
       1. Suggested Output Delivery System (ODS) Styles
       2. Applying Multiple Styles to Your Table
       3. Common Style Attributes
       4. Default Style Attributes for Table Regions
       5. STYLE= Option Syntax for PROC TABULATE Statements
       6. Style Elements and Style Attributes for Table Regions
       7. ODS ESCAPECHAR Statement Functions
12. 1. Appendix 1: PROC TABULATE Syntax
       1. Basic Syntax
       2. Available Statistics
       3. PROC TABULATE Operators:
13. Recommended Reading
14. Index
15. Additional Resources