SAS Certified Professional Prep Guide

Scenario 7

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*/
   create table work.bonus as     /*2*/
   select EmpId, Jobcode, Salary, /*3*/
         Salary*.10 as Bonus      /*4*/
      from certadv.empdata        /*5*/
      order by JobCode, Salary;   /*6*/
quit;

1	The SQL procedure retrieves data from tables or views to generate a report.
2	The CREATE TABLE statement creates the temporary table Work.Bonus from the query result of the current PROC SQL query.
3	The SELECT statement retrieves the EmpId, Jobcode, and Salary columns and displays the column values in the query result.
4	The SELECT statement ...