Proc Tabulate by Example

Table of Contents......Page 4
Acknowledgments......Page 6
Introduction......Page 10
Why Use PROC TABULATE?......Page 12
Example Using PROC TABULATE......Page 13
PROC TABULATE Syntax......Page 16
Before You Start Writing PROC TABULATE Code......Page 20
What Are You Trying to Show?......Page 21
Examining the Data......Page 23
Drawing a Picture of the Table......Page 25
The Basics......Page 28
Creating One- Dimensional Tables......Page 30
Making the Simplest Table Possible......Page 31
Adding a Statistic......Page 33
Adding a Classification Variable......Page 35
Putting It All Together......Page 37
Creating Two- Dimensional Tables......Page 40
Turning a One- Dimensional Table into a Two- Dimensional Table......Page 41
Statistic Definitions for a Two- Dimensional Table......Page 43
Adding Classification Variables on Both Dimensions......Page 45
Adding Another Classification Variable......Page 47
Nesting the Classification Variables......Page 49
Adding Statistics to the Nested Variables......Page 51
Adding Totals to the Rows and Columns......Page 53
Adding Subtotals......Page 55
Putting It All Together......Page 57
Creating Three- Dimensional Tables......Page 60
Start with Building the Two- Dimensional Table......Page 61
Comparison to Using a BY Statement......Page 63
More Complex Page Dimensions: Adding a Page for the Totals......Page 65
Putting a Title in Each Table......Page 67
Fitting Tables to the Page......Page 69
Intermediate Topics......Page 72
Handling Percentages with Complex Denominators......Page 86
Percentages for Multiple Row Variables......Page 87
Percentages for Multiple Column Variables......Page 89
Picking the Right Denominator......Page 91
Percentages Mixed with Other Statistics......Page 93
Percentages with Subtotals......Page 95
Percentage Subtotals on Both Dimensions......Page 97
Percentages for Three- Dimensional Tables......Page 99
Percentages for Analysis Variables......Page 101
Handling Missing Data......Page 104
Missing Data: How to Find It......Page 105
Reporting the Missing Data......Page 107
Recoding the Data......Page 109
Formatting Missing Values......Page 111
Three- Dimensional Tables with Missing Data......Page 113
Breaking Up the Table......Page 115
DATA Step Tricks......Page 117
Modifying Row and Column Headings......Page 120
Modifying Variable Labels......Page 121
Modifying Statistic Labels......Page 123
Another Way to Modify Statistic Labels......Page 125
Hiding Statistic Labels......Page 127
Hiding Variable Labels......Page 129
Modifying Row Headings......Page 131
Modifying Row Heading Widths......Page 133
Modifying Row Heading Indents......Page 135
Modifying Column Widths......Page 137
Ordering the Headings......Page 139
Reordering the Headings......Page 141
Formatting Table Values......Page 144
Using Appropriate Formats - I......Page 145
Using Appropriate Formats - II......Page 147
Formatting Percentages......Page 149
Formatting Large Numbers......Page 151
Weighting the Results......Page 153
Modifying the Table Grid......Page 156
Left- Justifying the Table......Page 157
Removing the Row Dividers......Page 159
Modifying the FORMCHAR Setting......Page 161
Fitting More Tables on the Page: CONDENSE and NOCONTINUED......Page 163
Making the Table Fit on the Page......Page 166
Reformatting CLASS Variables......Page 167
Reducing the Space Used by Row Headings......Page 169
Reducing the Column Widths......Page 171
Reformatting the Column Variables......Page 173
Moving the Statistics......Page 175
Rotating the Table......Page 177
Removing a Heading by Putting It in the Table BOX......Page 179
Removing the Row Separators......Page 181
Changing the Font Size......Page 183
Exporting the Table to Spreadsheet......Page 185
Splitting Up the Table......Page 187
Advanced Topics......Page 190
Using Macros to Generate Tables......Page 192
Repeating a Table for a Series of CLASS Variables......Page 193
Repeating a Table for a Series of Statistics......Page 195
Repeating a Table for Various Time Periods - I......Page 197
Repeating a Table for a Series of Time Periods - II......Page 199
Creating a Generic Macro to Produce Tables......Page 201
PROC TABULATE Tricks: How to Cheat to Create Complex Tables......Page 204
Matching the Table Design to Predefined Specifications......Page 205
Renaming the Statistics and Variables......Page 207
Calculating Percentages Another Way......Page 209
Displaying the Results of Multiple- Response Questions......Page 211
Using a Variable for Both Classification and Analysis......Page 213
Creating a One- Dimensional Table That Runs Vertically......Page 215
Handling CLASS Variables with Missing Data......Page 217
Creating Footnote References in Table Cells - I......Page 219
Creating Footnote References in Table Cells - II......Page 221
Creating Footnotes to Show Additional Statistical Results......Page 223
Outputting the Results......Page 226
Exporting Tables to a Spreadsheet: Creating the File......Page 227
Exporting Tables to a Spreadsheet: Importing the Files......Page 229
Exporting Tables to a Word Processor......Page 233
Exporting Tables to HTML......Page 237
Adding Hyperlinks to HTML Output......Page 239
Converting PROC TABULATE Output to a Word Processor Table via HTML......Page 241
Common Errors......Page 244
Troubleshooting Your Table......Page 246
Error Messages and What They Mean......Page 252
Type of name is unknown”......Page 253
Statistic other than N was requested without analysis variable”......Page 255
Multiple statistics associated with a single table cell”......Page 257
Multiple analysis variables associated with a single table cell”......Page 259
Class variable is missing on every observation”......Page 261
PCTN base is not in table”, “ PCTN crossing has no denominator”......Page 263
Incorrect Tables and How to Fix Them......Page 266
Number of Observations Seems too Small......Page 267
Some of the Values of the CLASS Variable Are Not Shown......Page 269
A Format Is Not Being Applied to a Variable......Page 271
Blank Label Is Not Being Applied to a Variable......Page 273
A Statistic’s Label Is Blank, but a Space Is Left In the Row Label......Page 275
Statistics Labels Do Not Appear Next to the Correct Variable......Page 277
Statistics Are Grouped Incorrectly......Page 279
Something Is Wrong with the Column Headings......Page 281
FUZZ Option Does Not Work......Page 283
FUZZ Option Does Not Work - the Solution......Page 285
Limitations of PROC TABULATE and How to Get Around Them......Page 288
Quantile Statistics ( Version 6)......Page 289
Advanced Statistical Tests......Page 291
Printing Record Details......Page 293
Formatting Text Values......Page 295
Complex Table Designs......Page 297
Creating an Output Data Set - I ( Version 6)......Page 299
Creating an Output Data Set - II ( Version 6)......Page 301
Special Topics......Page 304
PROC TABULATE Options Reference......Page 306
PROC TABULATE Statement Options......Page 307
Recommended PROC TABULATE Statement Option Settings......Page 308
TABLE Statement Options......Page 309
Recommended TABLE Statement Option Settings......Page 310
Recommended System Option Settings......Page 311
New PROC TABULATE Statement Options......Page 312
New CLASS Statement Options......Page 313
Recommended Version 7 Option Settings......Page 314
FORMCHAR Settings Reference......Page 316
Using the New FORMCHAR Setting......Page 317
Creating Tables Using SAS/ ASSIST Software......Page 320
Step 2: Identify Your Data Set......Page 321
Step 3: Launch SAS/ ASSIST......Page 322
Step 4: Pick a Table Design......Page 324
Step 5: Selecting a Data Set......Page 325
Step 6: Selecting an Analysis Variable......Page 326
Step 7: Selecting a CLASS Variable......Page 327
Step 8: Selecting the Statistics......Page 328
Step 9: Requesting Column Totals......Page 329
Step 10: First Test Run......Page 330
Step 11: Reviewing the Code......Page 331
Step 12: Modifying the Table......Page 332
Step 13: Second Test Run......Page 333
Step 14: Saving the Code......Page 334
Base SAS Changes: New Naming Conventions......Page 337
Other Base SAS Changes......Page 339
Quantile Statistics: Medians......Page 341
Quantile Statistics: Other Percentiles......Page 343
CLASS Statement Options: PRELOADFMT......Page 345
CLASS Statement Options: EXCLUSIVE......Page 347
CLASS Statement Options: MISSING......Page 349
CLASS Statement Options: ORDER......Page 351
CLASS Statement Options: DESCENDING, ASCENDING......Page 353
CLASSDATA Option......Page 355
Other New Options......Page 357
Output Data Sets......Page 359
Output Delivery System......Page 361
Adding ODS Styles to Your Tables - I......Page 363
Adding ODS Styles to Your Tables - II......Page 365
ODS Styles for Tables......Page 369
ODS Style Templates for Tables......Page 370
References......Page 374
More Tips and Techniques for Intermediate and Advanced Users......Page 375
Index......Page 376