PROC SQL: Beyond the Basics Using SAS®

Chapter 3. Formatting Output

3.1	Introduction 86
3.2	Formatting 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.3	Formatting 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.4	Summary 107