A00-212

A00-212 practice questions, page 3 of 8, with answer review and explanations.

Question 11

The following SAS program is submitted: %let dept=prod; %let prod=merchandise; The following message is written to the SAS log: The value is "merchandise" Which SAS System option writes this message to the SAS log?

  1. %put the value is "&&&dept";
  2. %put the value is "&&&dept";
  3. %put the value is "&&&dept";
  4. %put the value is %quote (&&&dept);

Question 12

The SAS data set WORK.TEMPDATA contains the variables FMTNAME, START and LABEL and it consists of 10 observations. The following SAS program is submitted: Proc format cntlin=wor.tempdata; Run; What is the result of submitting the FORMAT procedure step?

  1. It uses the WORK.TEMPDATA SAS data set as input to create the format
  2. All formats created will be stored in two WORK.TEMPDATA SAS data set
  3. An ERROR message is written to the SAS log because the program is incomplete
  4. NO formats are created in this step

Question 13

The following SAS program is submitted: date view=sauser.ranch; describe; run; What is the result?

  1. The program creates a DATA step view called SASUSER.RANCH and places the program cod in the current editor window
  2. The program retrieves the SAS source code that creates the view and places it in the output window
  3. The program creates a DATA step view called SASUSER.RANCH and places it in the SAS log
  4. the program retrieves the SAS source code that creates the view and places it in the SAS log

Question 14

Which SAS procedure changes the name of a permanent format for a variable stored in a SAS data set?

  1. DATASETS
  2. MODIFY
  3. FORMAT
  4. REGISTRY

Question 15

Given the SAS data set ONE: ONE - DIVISION SALES - A 1234 - A 3654 - B 5678 - The following SAS program is submitted: Data_null_; Set one; By divition; If first.division then - Do; %let mfirst=sales; end; run; What is the value of the macro variable MFRIST when the program finishes execution?

  1. 1234
  2. sales
  3. 5678
  4. null