SAS Chapter 7: Creating And Applying User-defined Formats

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Moxleyv
M
Moxleyv
Community Contributor
Quizzes Created: 38 | Total Attempts: 21,964
| Attempts: 388
Quiz Flashcard
SettingsSettings
Please wait...
  • 1/10 Questions

    If you don't specify the LIBRARY= option, your formats are stored in Work.Formats, and they exist ...

    • Only for the current procedure.
    • Only for the current DATA step.
    • Only for the current SAS session
    • Permanently.
Please wait...
About This Quiz

This SAS Chapter 7 quiz focuses on creating and applying user-defined formats. It tests knowledge on format storage, correct procedure syntax, format naming rules, and label character limits, essential for effective data management in SAS.

SAS Quizzes & Trivia

Quiz Preview

  • 2. 

    Which of the following FORMAT procedures is written correctly?

    • Proc format lib=library      value colorfmt;            1='Red'            2='Green'            3='Blue' run;

    • Proc format lib=library;      value colorfmt            1='Red'            2='Green'            3='Blue'; run;

    • Proc format lib=library;      value colorfmt;            1='Red'            2='Green'            3='Blue' run;

    • Proc format lib=library;      value colorfmt            1='Red';            2='Green';            3='Blue'; run;

    Correct Answer
    A. Proc format lib=library;      value colorfmt            1='Red'            2='Green'            3='Blue'; run;
    Explanation
    A semicolon is needed after the PROC FORMAT statement. The VALUE statement begins with the keyword VALUE and ends with a semicolon after all the labels have been defined.

    Rate this question:

  • 3. 

    Which of the following statements will store your formats in a permanent catalog?

    • Libname library 'c:\sas\formats\lib'; proc format lib=library       ...;

    • Libname library 'c\sas\formats\lib'; format lib=library      ...;

    • Library='c:\sas\formats\lib'; proc format library      ...;

    • Library='c:\sas\format\lib'; proc library      ...;

    Correct Answer
    A. Libname library 'c:\sas\formats\lib'; proc format lib=library       ...;
    Explanation
    To store formats in a permanent catalog, you first write a LIBNAME statement to associate the libref with the SAS data library in which the catalog will be stored. Then add the LIB= (or LIBRARY=) option to the PROC FORMAT statement, specifying the name of the catalog.

    Rate this question:

  • 4. 

    How many characters can be used in a label?

    • 40

    • 96

    • 200

    • 256

    Correct Answer
    A. 256
    Explanation
    When specifying a label, enclose it in quotation marks and limit the label to 256 characters.

    Rate this question:

  • 5. 

    When creating a format with the VALUE statement, the format's new name
    • cannot end with a number
    • cannot end with a period
    • cannot be the name of a SAS format, and...

    • Cannot be the name of a data set variable.

    • Must be at least two characters long.

    • Must be at least eight characters long.

    • Must begin with a dollar sign ($) if used with a character variable.

    Correct Answer
    A. Must begin with a dollar sign ($) if used with a character variable.
    Explanation
    The name of a format that is created with a VALUE statement must begin with a dollar sign ($) if it applies to a character variable.

    Rate this question:

  • 6. 

    The format JOBFMT was created in a FORMAT procedure.  Which FORMAT statement will apply to the variable JobTitle in the program output?

    • Format jobtitle jobfmt;

    • Format jobtitle jobfmt.;

    • Format jobtitle=jobfmt;

    • Format jobtitle='jobfmt';

    Correct Answer
    A. Format jobtitle jobfmt.;
    Explanation
    To associate a user-defined format with a variable, place a period at the end of the format name when it is used in the FORMAT statement.

    Rate this question:

  • 7. 

    Which of these is false?  Ranges in the VALUE statement can specify... 

    • A single value such as 24 or 's'.

    • A range of numeric values, such as 0-1500.

    • A range of character values, such as 'A'-'M'.

    • A list of numeric and character values separated by commas, such as 90,'B','D',270.

    Correct Answer
    A. A list of numeric and character values separated by commas, such as 90,'B','D',270.
    Explanation
    You can list values separated by commas, but the list must contain either all numeric or character.

    Rate this question:

  • 8. 

    You can place the FORMAT statement in either a DATA step or a PROC step.  What happens when you place it in a DATA step?

    • You temporarily associate the formats with variables.

    • You permanently associate the formats with variables.

    • You replace the original data with the format labels.

    • You make the formats available to other data sets.

    Correct Answer
    A. You permanently associate the formats with variables.
    Explanation
    By placing the FORMAT statement in a DATA step, you permanently associate the defined format with variables.

    Rate this question:

  • 9. 

    Which keyword can be used to label missing numeric values as well as any values that are not specified in the range?

    • LOW

    • MISS

    • MISSING

    • OTHER

    Correct Answer
    A. OTHER
    Explanation
    MISS and MISSING are invalid keywords, and LOW does not include missing numeric values. The keyword OTHER can be used in the VALUE statement to label missing values as well as any values that are not specifically included in a range.

    Rate this question:

  • 10. 

    Which keyword, when added to the PROC FORMAT statement, will display all the formats in your catalog?

    • CATALOG

    • LISTFMT

    • FMTCAT

    • FMTLIB

    Correct Answer
    A. FMTLIB
    Explanation
    Adding the keyword FMTLIB to the PROCFORMAT statement displays a list of all the formats in your catalog, along with descriptions of their values

    Rate this question:

Quiz Review Timeline (Updated): Mar 22, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 22, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Jan 21, 2013
    Quiz Created by
    Moxleyv
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.