SAS Certified Professional Prep Guide

Quiz

Select the best answer for each question. After completing the quiz, check your answers using the answer key in the appendix.

1. Which of the following correctly creates a macro variable in a PROC SQL step?

   1. proc sql noprint;
         select avg(Days)
            into:NumDays
            from certadv.all;
      quit;
      %put &=NumDays;

   2. proc sql noprint;
         select avg(Days)
            into NumDays
            from certadv.all;
      quit;
      %put &=NumDays;

   3. proc sql noprint;
         select avg(Days) as NumDays
            from certadv.all;
      quit;
      %put &=NumDays;

   4. proc sql noprint;
         select Days 
            into avg(Days) as NumDays
            from certadv.all;
      quit;
      %put &=NumDays;

2. Suppose you are asked to create a report of the courses that are offered in all three available locations. The report should not contain any ...