O'Reilly logo

SAS Certification Prep Guide, 4th Edition by SAS Institute

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required