SAS Certified Professional Prep Guide

Scenario 8

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 number;                              /*1*/
   select empdata.empID,                      /*2*/
          empdata.LastName,
          empdata.Salary, 
          newsals.NewSalary, 
         (newsals.NewSalary-empdata.Salary)   /*3*/
            as Raise format=dollar10.2        
      from certadv.empdata inner join         /*4*/
           certadv.newsals   
           on empdata.EmpID= newsals.EmpID    /*5*/
      where calculated Raise>3000             /*6*/
      order by EmpID;                         /*7*/
quit;

1	The SQL procedure retrieves data from tables or views to generate a report. The PROC SQL option NUMBER prints the row numbers in the query output.
2	The SELECT statement retrieves the columns ...