SAS Certified Professional Prep Guide

Scenario 5

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:

%macro CourseLoc;                          /*1*/
proc sql noprint;
   select distinct Location into:
      loc1-
      from certadv.schedule;
quit;
%do i=1 %to &sqlobs;                       /*2*/
title "Courses Offered in &&loc&i";
proc print data=certadv.schedule;
   where location="&&loc&i";
run;
%end;
%mend CourseLoc;                           /*3*/

%Courseloc                                 /*4*/

1	The %MACRO statement defines the macro CourseLoc. The macro itself executes a PROC SQL query where a series of macro variables are created. The macro variables store distinct values of the Location column from the Certadv.Schedule data set. ...