PROC SQL: Beyond the Basics Using SAS, Second Edition, 2nd Edition

Chapter 3: Formatting Output

Introduction

Formatting Output

Writing a Blank Line between Each Row

Displaying Row Numbers

Using the FORMAT= Column Modifier to Format Output

Concatenating Character Strings

Inserting Text and Constants between Columns

Using Scalar Expressions with Selected Columns

Ordering Output by Columns

Grouping Data with Summary Functions

Grouping Data and Sorting

Subsetting Groups with the HAVING Clause

Formatting Output with the Output Delivery System

ODS and Output Formats

Sending Output to a SAS Data Set

Converting Output to Rich Text Format

Exporting Data and Output to Excel

Delivering Results to the Web

Summary

 

Introduction

Programmers want and expect to be able to format output in a variety of ways. The SQL procedure ...