Quiz

Select the best answer for each question. After completing the quiz, check your answers using the answer key in the appendix.
  1. Which PICTURE statement displays a nine-digit account number with six leading asterisks followed by the last five digits, such as ******56789? 
    1. picture actfmt low-high='99999'(prefix='******');
    2. picture actfmt (prefix='******') low-high='99999';
    3. picture actfmt low-high='999999999' (prefix='******');
    4. picture actfmt (prefix='*****') low-high='999999999';
  2. Which PICTURE statement generates a date format that produces the following results when used with the Date column?
    Generate a date format that takes the input date of 21793 and converts to 9/1/2019.
    1. picture DateFmt low-high='%m/%d/%Y' (datatype=date);
    2. picture DateFmt (default=10 )low-high='%m/%d/%Y' 
                  (datatype=date);

    3. picture DateFmt low-high='%m/%d/%Y' 
                  (datatype=date default=10);

    4. picture DateFmt (default=10) low-high='%m/%d/%Y' 
                  (datatype=datetime);
  3. Which of the following are format options that can be placed after the format name?
    PICTURE format-name<(format-options)>
    <value-range-set-1 = 'template-value' (template-options)>
    <value-range-set-n = 'template-value' (template-options)>;
    1. DEFAULT=
    2. DATATYPE=
    3. MULTIPLIER=
    4. ROUND
    5. a and d only.
    6. b and c only.
  4. What system option do you have to specify in order to use the new function that you created in a DATA step or a supported PROC step?
    1. FCMPLIB=
    2. LIBCMP=
    3. CMPLIB=
    4. OUTLIB=
  5. Which directives create the following value?
    2019.03.19 @ 8:25:19 PM
    1. %Y.%m.%d@%H:%M:%S%p
    2. %Y.%m.%d@%I:%0M:%0S%p
    3. %Y.%0m.%0d @ %I:%0M:%0S%p
    4. %0Y.%0m.%0d@%H:%0M:%0S%p
  6. Complete the FUNCTION statement to create a function named TitleName that consists of two character arguments. 
    proc fcmp outlib=certadv.functions.samp;
   function TitleName ___________________ $50;
      if JobCode='S' then return(catx(' ','Software',',JobTitle'));
      else if JobCode='M' then return(catx(' ','Manager of ',',JobTitle'));
    1. (JobTitle, JobCode)
    2. (JobTitle $, JobCode $)
    3. ('JobTitle' $, 'JobCode' $)
    4. ('JobTitle $', 'JobCode $')
  7. Which statement is true concerning the following PROC FCMP statement?
    proc fcmp outlib=certadv.funcs.dev;
    1. The custom function will be stored in the SAS table Funcs.Dev.
    2. The custom function will be stored in the Certadv package within the SAS table Funcs.Dev.
    3. The custom function will be stored in the Dev folder within the SAS package Certadv.Funcs.
    4. The custom function will be stored in the Dev package within the SAS table Certadv.Funcs.
Last updated: October 16, 2019
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.224.62.6