SAS Unit 11: Custom Formats

Which of the following contains valid syntax?

• value grades 'A'='Excellent' 'B'='Good';

• value qtrfmt 1,2,3='First' 4,5,6='Second';

• value $grades. 'A'='Excellent' 'B'='Good';

• value qtrfmt '1'-'3'='First' '4'-'6'='Second';

What is the formatted value for the value of 100 given the following step?

• low

• medium

• high

• out of range

In the FORMAT procedure, you specify the name of the format and the name of the column that will use the custom format.

• True

• False

What is the correct formatted output given the following PROC FORMAT step and the input table?

• 
• 
• 
• 

Which of the following does not have proper syntax for specifying a range in the VALUE statement?

• 500>-700

• 500-<700

• 'A'-'C'

• 'Horse'-'Mouse'

Which statement is true concerning options for the FORMAT procedure?

• The FMTLIB option goes in the SELECT statement.

• The CNTLIN= option goes in the VALUE statement.

• The FMTLIB option specifies the library to store the format.

• The CNTLIN= option specifies a table from which formats are built.

Which columns are required in an input table to create a format based on numeric ranges?

• FMTNAME, START, and LABEL

• FORMAT, START, END, and NAME

• FMTNAME, START, END, and LABEL

• FORMAT, START, LAST, NAME, and TYPE

Which option in the PROC FORMAT statement specifies a library to store a custom format?

• CATALOG=

• FMTLIB=

• LIBRARY=

• STORE=

What is the default search order that is used to locate formats?

• LIBRARY.FORMATS > WORK.FORMATS

• SASHELP.FORMATS > LIBRARY.FORMATS

• SASHELP.FORMATS > WORK.FORMATS

• WORK.FORMATS > LIBRARY.FORMATS

Which of the following contains valid syntax for the FMTSEARCH= option?

• options fmtsearch=sashelp;

• options fmtsearch=sashelp.formats;

• options fmtsearch=(sashelp sashelp.fmts);

• options fmtsearch=[sashelp.fmts sashelp];