SAS Certified Professional Prep Guide

Scenario 6

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:

%let job=Analyst;                                   /*1*/
data work.staff;                                    /*2*/
   keep employeeID jobtitle salary;
   set certadv.staff;
   where jobtitle contains "&job";                  /*3*/
   total+salary;
   count+1;
   call symputx('avg',put(total/count,dollar9.));   /*4*/
run;
title "&job Staff";                                 /*5*/
footnote "Average Salary: &avg";                    /*6*/
proc print data=work.staff;
   sum salary;
run;

1	The %LET statement creates the macro variable Job and assigns the value of Analyst.
2	The DATA step creates a temporary SAS data set Work.Staff. Work.Staff that contains only the variables ...