SAS Chapter 17: Formatting Data

10 Questions | By Moxleyv | Last updated: Mar 20, 2022 | Total Attempts: 186

Questions

Settings

Create your own Quiz

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