SAS Certification Prep Guide, 4th Edition

Quiz

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

1. Which type of integrity constraint would you place on the variable StoreID to ensure that there are no missing values and that there are no duplicate values?

   1. UNIQUE
   2. CHECK
   3. PRIMARY KEY
   4. NOT NULL
2. Which code creates an audit trail on the SAS data set Reports.Quarter1?

   1. proc datasets nolist;
         audit quarter1;
         initiate;
      quit;

   2. proc datasets lib=reports nolist;
         audit initiate reports.quarter1;
      quit;

   3. proc datasets lib=reports nolist;
         initiate audit quarter1;
      quit;

   4. proc datasets lib=reports nolist;
         audit quarter1;
         initiate;
      quit;

3. Which DATA step uses the transaction data ...