PROC SQL: Beyond the Basics Using SAS®

3.4. Summary

1. A blank line can be displayed between each row of output (see section 3.2.1).

2. Columns can be concatenated to form a single column of data (see section 3.2.3).

3. Text and constants can be inserted between selected columns (see section 3.2.4).

4. Numeric or character scalar values can be produced with expressions (see section 3.2.5).

5. User-defined values can be assigned to derived column headers (see section 3.2.5).

6. Formats can be assigned and stored permanently to automatically display a user-defined formatted value instead of the unformatted value (see section 3.2.5).

7. Columns do not have to appear as unordered sets of data. One or more columns can be arranged in ascending or descending order (see section 3.2.6).

8. Selected columns can be organized ...