SAS Chapter 17: Formatting Data
Practice for the advance SAS certification exam
- 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.
.
Questions: 10 | Attempts: 856 | Last updated: Mar 7, 2013
-
Sample QuestionHow many observations and variables does the data set below contain?
Questions: 11 | Attempts: 538 | Last updated: Mar 7, 2013
-
Sample QuestionAs you write and edit SAS programs it's a good idea to
Questions: 10 | Attempts: 327 | Last updated: Mar 8, 2013
-
Sample QuestionWhich of the following is not created during the compilation phase?
Back to top