售价: 论坛币 10 个[记录][购买]
【分享】Carpenter’s Complete Guide to the SAS ®REPORT Procedure
Copyright © 2007, SAS Institute Inc., Cary, NC, USA
ISBN 978-1-59994-195-0

Contents


Preface xi
Acknowledgments xiii
About the Author xv
How to Use This Book and the Accompanying CD xvii

Part 1 Getting Started
Chapter1 Creating a Simple Report 3
1.1 Basic Syntax 4
1.2 Routing Reports to ODS Destinations 6
1.3 Other Reporting Tools:A Brief Comparison of Capabilities 7
1.3.1PROC REPORT vs. PROC PRINT8
1.3.2PROC REPORT vs. PROC TABULATE 8
1.3.3PROC REPORT vs. DATA _NULL_ 8
1.4 The PROC REPORT Process:An Overview 9
1.4.1PROC REPORT Terminology 9
1.4.2Processing Phases 11
1.5 Chapter Exercises 12

Chapter2 PROC REPORT: An Introduction 13
2.1 Introduction to the COLUMN Statement 16
2.2 Defining Types of Columns 17
2.2.1Default Define Types DISPLAY and ANALYSIS 18
2.2.2Using Define Usage ORDER 19
2.2.3Using Define Type GROUP 22
2.2.4Using Define Type ACROSS (and GROUP) 24
2.3 Doing More on the COLUMN Statement 25
2.3.1Using the Comma to Form Nested Associations 26
2.3.2Attaching Statistics with a Comma 26
2.3.3Using Parentheses to Form Groups 28
2.3.4Nesting Statistics under an ACROSS Variable 29
2.4 Other DEFINE Statement Options 31
2.4.1Specification of an Analysis Statistic 31
2.4.2Formatting the Values 33
2.4.3Controlling the Order of the Displayed Values 34
2.4.4Using the N Statistic without an ANALYSIS Variable 36
2.4.5Associating Statistics with DEFINE Statements 37 iv Contents
2.5 Adding Text 39
2.5.1Using the COLUMN Statement to Add Text 41
2.5.2Using the DEFINE Statement to Add Text 43
2.5.3Using the SPLIT= Option with Text 44
2.6 Compute Blocks 45
2.6.1Inserting a Blank Line 46
2.6.2Adding Lines of Text 47
2.6.3Writing Formatted Values 49
2.6.4Using SAS Language Elements 51
2.7 Sequencing of Step Events 52
2.8 Chapter Exercises 54

Chapter3 Creating Breaks 57
3.1Generating Breaks Using BREAK and RBREAK 57
3.2BREAK Statement 59
3.2.1Skipping a Line between Groups 59
3.2.2Summarizing across a Group 61
3.2.3Suppressing the Summarization Label 65
3.2.4Generating a Page for Each Group Level 67
3.2.5Combining Summaries with Detail Reports 68
3.3RBREAK Statement 69
3.3.1Using RBREAK in a Detail Report 69
3.3.2Using RBREAK with BREAK in a Detail Report 70
3.3.3Using RBREAK and BREAK in a Summary Report 71
3.4Chapter Exercises 73

Chapter4 Only in the LISTING Destination 75
4.1Using the HEADLINE and HEADSKIP Options 76
4.2Blank Lines, Overlines, and Underlines 78
4.3Repeat Characters 79
4.3.1Adding Repeated Characters to Spanning Headers 80
4.3.2Repeat Characters with the SPLIT= Option 82
4.4PROC REPORT Statement Options83
4.4.1Creating Boxes on the Report 83
4.4.2Controlling the Centering of the Report 85
4.4.3Adjusting the Width of Numeric and Computed Columns 85
4.4.4Creating Multiple Panels on a Page 86
4.4.5Using the PSPACE= Option 87
4.4.6Controlling the Size of the Page 88
4.4.7Using the FORMCHAR Option 89
4.4.8Wrapping Data Lines 91 Contents v

4.5Other DEFINE Statement Options 92
4.5.1Specifying the Column Width 93
4.5.2Using the FLOW Option to Wrap Text 93
4.5.3Adding Spaces between Columns 94
4.6Chapter Exercises 96

Chapter5 Creating and Modifying Columns Using the
Compute Block 97
5.1Coordinating with the COLUMN and DEFINE Statements 98
5.2Calculations Based on Statistics 99
5.3Calculating Percentages within Groups 101
5.4Using _PAGE_ with BEFORE and AFTER 103
5.5Using the OUT= Option to View Report Break Information 104
5.6Chapter Exercises 106


Part 2 Taking PROC REPORT Beyond the
Basics
Chapter6 Refining Our Understanding of the
PROC REPORT Step 109
6.1Additional DEFINE Statement Options 110
6.1.1Changing Display Order with DESCENDING 110
6.1.2Specification of Column Justification 111
6.1.3Allowing the Use of Missing Classification Items 113
6.1.4Controlling the Use of Analysis Items with All Missing or
Zero Values 115
6.1.5Using NOPRINT 118
6.1.6Identification Columns 119
6.1.7Creating Vertical Page Breaks 120
6.2Using Variable Aliases 121
6.3Nesting Variables 122
6.4Taking Full Advantage of Formats 123
6.4.1User-Defined Formats 123
6.4.2Preloading Formats 126
6.4.3Order Based on Format Definition 130
6.5Other PROC Statement Options 131
6.5.1Removing Headers 131
6.5.2Using NAMED Output 132
6.5.3Debugging with the LIST Option 134
6.5.4Including MISSING Classification Levels 134 vi Contents
6.6BY-Group Processing 136
6.6.1Using the BY Statement 137
6.6.2Creating Breaks with BY Groups 138
6.6.3Using the #BYVAL and #BYVAR Options 139
6.6.4BY Groups and the Output Delivery System 141
6.7Calculations Using the FREQ Statement 144
6.8A Further Comment on Paging Issues 145
6.9Chapter Exercises 146

Chapter7 Extending Compute Blocks 147
7.1Understanding the Events of the Compute Block Process 149
7.1.1Setup Phase: Generating the Computed Summary
Information 150
7.1.2Report Row Phase: Generating the Report 150
7.1.3Process Example 151
7.2Referencing Columns and Report Items in a Compute Block 154
7.2.1Using Direct Variable Name References 156
7.2.2Using Compound Variable Names 159
7.2.3Using an Alias as a Column Reference 160
7.2.4Using Absolute Column References: Referring to a Column
by Its Number 161
7.2.5Using the Automatic Temporary Variable _BREAK_ 164
7.3Using BEFORE and AFTER 166
7.4Changing the Grouping Variable Values on Summary Lines 169
7.4.1Specifying Text in a Compute Block 170
7.4.2Using a Formatted Value 171
7.4.3Creating a Dummy Column 173
7.5Introducing the CALL DEFINE Routine 174
7.6COMPUTE Statement Options and Switches 179
7.6.1Justification of LINE Statement Text 179
7.6.2Creating Character Variables with the CHARACTER and
LENGTH= Options 180
7.7Using Logic and SAS Language Elements 182
7.7.1Using the SUM Statement with Temporary Variables 183
7.7.2Repeating GROUP and ORDER Variables on Each Row 185
7.7.3Counting Items across Page Breaks in the LISTING
Destination 187
7.8Doing More with the LINE Statement 191
7.8.1Creating Group Summaries 192
7.8.2Adding Repeated Characters 194
7.8.3Understanding LINE Statement Execution 197 Contents vii

7.9Examples of Common Tasks 199
7.9.1Writing a Grand Total on Every Page 200
7.9.2Combining Values into One Field or Column 202
7.9.3Combining Values with Nested ACROSS Variables 204
7.9.4Calculating a Weighted Mean 206
7.10Chapter Exercises 209

Chapter8 Using PROC REPORT with ODS 211
8.1Introduction to the STYLE= Option 213
8.2Using STYLE= to Change Attributes 216
8.2.1Changing Text and Cell Attributes 216
8.2.2Adding a Logo to Your Report 219
8.2.3Controlling Report Size 223
8.2.4Adding Horizontal and Vertical Spaces to Separate
Data 223
8.3Using CALL DEFINE to Change Style Attributes 227
8.3.1Using CALL DEFINE in a Simple Report 228
8.3.2Creating Shaded Rows 229
8.3.3Conditional Assignment of Attributes 231