SAS Chapter 17: Formatting Data

10 Questions | Total Attempts: 126

SettingsSettingsSettings
SAS Quizzes & Trivia

Practice for the advance SAS certification exam


Questions and Answers
  • 1. 
    Which SAS system option is used to identify format catalogs to SAS?
    • A. 

      FMTERR

    • B. 

      FMTLIB

    • C. 

      NOFMTERR

    • D. 

      FMTSEARCH=

  • 2. 
    Given the following PROC FORMAT step, how is the value 70 displayed when the AGEGRP. format is applied? proc format; picture agegrp 1-<13='00 Youth' 13-<20='00 Teen' 20-<70='00 Adult' 70-high='000 Senior'; run;
    • A. 

      000 Senior

    • B. 

      70 Adult

    • C. 

      70 Senior

    • D. 

      070 Senior

  • 3. 
    When the NOFMTERR system option is in effect, what happens when SAS encounters a format it cannot locate?
    • A. 

      Creates the format in the default Work.Formats directory and continues processing.

    • B. 

      Substitutes the $w.or w. format and continues processing.

    • C. 

      Stops processing and writes an error message to the log.

    • D. 

      Skips processing at that step and continues with the next step and writes a note to the log.

  • 4. 
    Which of the following variables must be in the data set that is specified on the CNTLIN= option?
    • A. 

      End

    • B. 

      FmtName

    • C. 

      Value

    • D. 

      Description

  • 5. 
    Given the following code, what option is missing? proc format; value times (?)  '00:00't-'04:59't = 'Red Eye' '05:00't-'11:59't = 'Morning' '12:00't-'17:59't = 'Afternoon' '18:00't-'23:59't = 'Evening' '00:00't-'11:59't = 'AM' '12:00't-'23:59't = 'PM'; run;
    • A. 

      MULTILABEL

    • B. 

      MULTIRANGE

    • C. 

      MLF

    • D. 

      MULTIFORMAT

  • 6. 
    Which PROC FORMAT option is used to create a SAS data set from a format?
    • A. 

      CNTLIN=

    • B. 

      LIB=

    • C. 

      CNTLOUT=

    • D. 

      FMTLIB

  • 7. 
    Given the following OPTIONS statement, in what order will SAS search to find a user-defined format? options fmtsearch=(work abc.newfmt sasuser);
    • A. 

      Work.Formats   Abc.Newfmt   Sasuser.Formats   Library.Formats

    • B. 

      Work.Formats   Library.Formats   Abc.Newfmt   Sasuser.Formats

    • C. 

      Work.Formats   Abc.Newfmt   Sasuser.Format

    • D. 

      The default search order

  • 8. 
    What option is used with PROC FORMAT to document the formats in a particular format catalog?
    • A. 

      FMTSEARCH

    • B. 

      FMTERR

    • C. 

      CATALOG

    • D. 

      FMTLIB

  • 9. 
    Which set of statements would you add to the PROC CATALOG code to copy the LEVELS. and $PICKS. formats from theSasuser.Formats catalog to the Work.Formats catalog? proc catalog cat=sasuser.formats; ?  ?  run;
    • A. 

      copy out=sasuser.formats; select levels.format $picks.format;

    • B. 

      copy out=work.formats; select levels $picks;

    • C. 

      copy out=work.formats; select levels.format picks.formatc;

    • D. 

      copy out=work.formats; select levels.format $picks.format;

  • 10. 
    Given the following PROC FORMAT step, how is the value 6.1 displayed when the SKICOND format is applied? proc format; value skicond 0-3='Poor' 3<-6='Fair' 6<-9='Good' 9<-high='Excellent'; run;
    • A. 

      6.1

    • B. 

      Fair

    • C. 

      Good

    • D. 

      .

Related Topics
Back to Top Back to top