SAS Certification Prep Guide, 4th Edition

Enhancing Query Output

Overview

When you are using PROC SQL, you might find that the data in a table is not formatted as you would like it to appear. Fortunately, with PROC SQL you can use enhancements, such as the following, to improve the appearance of your query output:

• column labels and formats
• titles and footnotes
• columns that contain a character constant.

You know how to use the first two enhancements with other SAS procedures. You can also enhance PROC SQL query output by working with the following query:

  proc sql outobs=15;
     select empid, jobcode, salary,
            salary * .10 as Bonus
        from sasuser.payrollmaster
        where salary>75000
        order by salary desc;

This query limits output to 15 observations. The SELECT clause selects three ...