Chapter 3: Working With Your Data ......................................................................................... 103
3.1 Creating and Redefining Variables ............................................................................ 103
3.2 Using SAS Functions .................................................................................................. 106
3.3 Selected SAS Character Functions .......................................................................... 109
3.4 Selected SAS Numeric Functions ............................................................................. 113
3.5 Using IF-THEN Statements ........................................................................................ 117
3.6 Grouping Observations with IF-THEN/ELSE Statements ..................................... 120
3.7 Subsetting Your Data .................................................................................................. 123
3.8 Working with SAS Dates ............................................................................................. 126
3.9 Selected Date Informats, Functions, and Formats ................................................. 130
3.10 Using the RETAIN and Sum Statements ............................................................... 134
3.11 Simplifying Programs with Arrays ............................................................................ 137
3.12 Using Shortcuts for Lists of Variable Names ......................................................... 140
Chapter 4: Sorting, Printing, and Summarizing Your Data ................................................... 144
4.1 Using SAS Procedures ............................................................................................... 144
4.2 Subsetting in Procedures with the WHERE Statement ......................................... 148
4.3 Sorting Your Data with PROC SORT ........................................................................ 151
4.4 Changing the Sort Order for Character Data ........................................................... 154
4.5 Printing Your Data with PROC PRINT ...................................................................... 157
4.6 Changing the Appearance of Printed Values with Formats ................................... 161
4.7 Selected Standard Formats ....................................................................................... 164
4.8 Creating Your Own Formats Using PROC FORMAT ............................................. 168
4.9 Writing Simple Custom Reports ................................................................................ 171
4.10 Summarizing Your Data Using PROC MEANS ..................................................... 174
4.11 Writing Summary Statistics to a SAS Data Set ..................................................... 177
4.12 Counting Your Data with PROC FREQ .................................................................. 180
4.13 Producing Tabular Reports with PROC TABULATE ............................................. 183
4.14 Adding Statistics to PROC TABULATE Output ..................................................... 186
4.15 Enhancing the Appearance of PROC TABULATE Output ................................... 189
4.16 Changing Headers in PROC TABULATE Output .................................................. 192
4.17 Specifying Multiple Formats for Data Cells in PROC TABULATE Output ......... 195
4.18 Producing Simple Output with PROC REPORT ................................................... 198
4.19 Using DEFINE Statements in PROC REPORT .................................................... 201
4.20 Creating Summary Reports with PROC REPORT ............................................... 204
4.21 Adding Summary Breaks to PROC REPORT Output .......................................... 207
4.22 Adding Statistics to PROC REPORT Output ......................................................... 210
4.23 Adding Computed Variables to PROC REPORT Output ..................................... 213
4.24 Grouping Data in Procedures with User-Defined Formats .................................. 216
Chapter 5: Enhancing Your Output with ODS ........................................................................ 219
5.1 Concepts of the Output Delivery System ................................................................. 219
5.2 Tracing and Selecting Procedure Output ................................................................. 222
5.3 Creating SAS Data Sets from Procedure Output .................................................... 226
5.4 Creating Text Output ................................................................................................... 229
5.5 Creating HTML Output ................................................................................................ 232
