A00-211

A00-211 practice questions, page 8 of 11, with answer review and explanations.

Question 36

The value 110700 is stored in a numeric variable named SALARY. Which FORMAT statement displays the value as $110,700.00 in a report?

  1. format salary comma11.2;
  2. format salary dollar8.2;
  3. format salary dollar11.2;
  4. format salary comma8.2 dollar8.2;

Question 37

Given the raw data file YEARAMT: ----|---10---|---20---|----30 1901 2 1905 1 1910 6 1925 . 1941 1 The following SAS program is submitted: data coins; infile yearamt; input year quantity; run; Which statement(s) completed the program and produced a non-missing value for the variable TOTQUANTITY in the final observation of the output data set?

  1. totquantity + quantity;
  2. totquantity = sum(totquantity + quantity);
  3. retain totquantity; totquantity = totquantity + quantity;
  4. retain totquantity0; totquantity = totquantity + quantity;

Question 38

Given the SAS data set EMPLOYEE INFO: EMPLOYEE_INFO - IDNumber - Expenses - 2542 100.00 3612 133.15 2198 234.34 2198 111.12 The following SAS program is submitted: proc sort data = employee_info; run; Which BY statement completes the program and sorts the data sequentially by ascending expense values within each ascending IDNUMBER value?

  1. by Expenses IDNumber;
  2. by IDNumber Expenses;
  3. by ascending Expenses IDNumber;
  4. by ascending IDNumber ascending Expenses;

Question 39

The following SAS program is submitted: proc format value score 1 - 50 = Fail 51 - 100 = Pass; run; proc report data = work.courses nowd; column exam; define exam / display format = score.; run; The variable EXAM has a value of 50.5. How will the EXAM variable value be displayed in the REPORT procedure output?

  1. Fail
  2. Pass
  3. 50.5
  4. . (missing numeric value)

Question 40

What is the purpose or the MISSOVER option on the INFILE statement?

  1. It prevents SAS from loading a new record when the end of the current record is reached.
  2. It enables SAS to scan the input data records until the character string that is specified in the @‘character-string’ expression is round.
  3. It enables SAS to continue to read the next input data record if it does not find values in the current input tine for all the variables in the statement.
  4. It causes the DATA step to stop processing if an INPUT statement reaches the end of the current record without finding values for all variables in the