Chapter 3. Formatting Output

3.1Introduction 86
3.2Formatting Output 86
 3.2.1 Writing a Blank Line Between Each Row 86
 3.2.2 Displaying Row Numbers 88
 3.2.3 Concatenating Character Strings 89
 3.2.4 Inserting Text and Constants Between Columns 90
 3.2.5 Using Scalar Expressions with Selected Columns 92
 3.2.6 Ordering Output by Columns 95
 3.2.7 Grouping Data with Summary Functions 97
 3.2.8 Grouping Data and Sorting 99
 3.2.9 Subsetting Groups with the HAVING Clause 100
3.3Formatting Output with the Output Delivery System 101
 3.3.1 ODS and Output Formats 102
 3.3.2 Sending Output to a SAS Data Set 103
 3.3.3 Converting Output to Rich Text Format 104
 3.3.4 Delivering Results to the Web 105
3.4Summary 107

Get PROC SQL: Beyond the Basics Using SAS® now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.