SAS Certified Professional Prep Guide

Scenario 9

Code Solution

Note: On the live exam, you will be evaluated both on the results of your code and the code itself. Your code should be similar to the following example code, but does not need to match exactly:

proc sql;                                                  /*1*/
   select catx(" ",'Total Paid to All',JobTitle,'Staff'),  /*2*/
      sum(Salary) format=dollar14.,                        /*3*/
      count(*) as TotalCount format=comma16.               /*4*
      from certadv.salesstaff                              /*5*/
      group by JobTitle;                                   /*6*/
quit;

1	The SQL procedure retrieves data from tables or views to generate a report.
2	The SELECT statement uses the CATX function to return a character string that combines 'Total Paid to All', the value of JobTitle, and 'Staff'. For example, for rows where JobTitle is Sales Rep. I, the concatenated string is ...