Select the best answer
for each question. After completing the quiz, check your answers using
the answer key in the appendix.
-
Which SAS system option
is used to identify format catalogs to SAS?
-
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;
-
When the NOFMTERR system
option is in effect, what happens when SAS encounters a format that
it cannot locate?
-
Creates the format in
the default Work.Formats directory and continues processing.
-
Substitutes the $
w.
or
w. format and continues
processing.
-
Stops processing and
writes an error message to the log.
-
Skips processing at
that step and continues with the next step and writes a note to the
log.
-
Which of the following
variables must be in the data set that is specified in the CNTLIN=
option?
-
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;
-
Which PROC FORMAT option
is used to create a SAS data set from a format?
-
Given the following
OPTIONS statement, in what order will SAS search to find a user-defined
format?
options fmtsearch=(work abc.newfmt sasuser);
-
Work.Formats>Abc.Newfmt>Sasuser.Formats>Library.Formats
-
Work.Formats>Library.Formats>Abc.Newfmt>Sasuser.Formats
-
Work.Formats>Abc.Newfmt>Sasuser.Format
-
-
What option is used
with PROC FORMAT to document the formats in a particular format catalog?
-
Which set of statements
would you add to the PROC CATALOG code to copy the LEVELS. and $PICKS.
formats from the Sasuser.Formats catalog to the Work.Formats catalog?
proc catalog cat=sasuser.formats;
?
?
run;
-
copy out=sasuser.formats;
select levels.format $picks.format;
-
copy out=work.formats;
select levels $picks;
-
copy out=work.formats;
select levels.format picks.formatc;
-
copy out=work.formats;
select levels.format $picks.format;
-
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;