SAS Institute SAS Institute Certifications A00-211 Questions & Answers

• Question 221:

  The following SAS program is submitted:

  Data_null_;

  set old;

  put sales 1 sales2;

  run;

  Where is the output written?

  A. to the SAS log

  B. to the SAS data set _NULL_

  C. to the SAS output window or to an output file D. to the raw data file that was most recently opened

  Correct Answer: A

• Question 222:

  The following SAS program is submitted:

  data work.test; array items{3} _temporary_; run;

  What are the names of the variable(s) in the WORKTEST data set?

  A. ITEMS

  B. ITEMS1, ITEMS2, ITEMS3

  C. No variables are created because it is a temporary array.

  D. The program fails to execute because there are no variables listed on the ARRAY statement.

  Correct Answer: C

• Question 223:

  Read the table

  

  The following SAS program is submitted:

  proc freq data = sales;

  run;

  The following output is created by the FREQUENCY procedure:

  

  Which TABLES statement(s) completed the program and produced the output?

  A. tables region product;

  B. tables region * product;

  C. tables product * region;

  D. tables product; tables region;

  Correct Answer: B

• Question 224:

  The following SAS program is submitted:

  data one; date = `04juI2005'd; format date weekdate.; run; proc print data = one; run;

  What output is generated?

  A. Obs date 1 Monday, July 4, 2005

  B. Obs date 1 July4, 2005

  C. Obs date 1 04Jul2005

  D. Obs date 1 Monday, 07/04/2005

  Correct Answer: A

• Question 225:

  The following SAS program is submitted:

  data test;

  set sasuser.employees;

  if 2 le years_service le 10 then

  amount = 1000;

  else amount = 0;

  amount_per_year = years_service / amount

  run;

  What is the value of the variable AMOUNT_PER_YEAR if an employee has been with the company for

  one year?

  A. 0

  B. 0.001

  C. 1

  D. . (missing numeric value)

  Correct Answer: D

• Question 226:

  The value 110700 is stored in a numeric variable named SALARY.

  Which FORMAT statement displays the value as $110,700.00 in a report?

  A. format salary comma11.2;

  B. format salary dollar8.2;

  C. format salary dollar11.2;

  D. format salary comma8.2 dollar8.2;

  Correct Answer: C

• Question 227:

  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?

  A. totquantity + quantity;

  B. totquantity = sum(totquantity + quantity);

  C. retain totquantity; totquantity = totquantity + quantity;

  D. retain totquantity0; totquantity = totquantity + quantity;

  Correct Answer: A

• Question 228:

  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?

  A. by Expenses IDNumber;

  B. by IDNumber Expenses;

  C. by ascending Expenses IDNumber;

  D. by ascending IDNumber ascending Expenses;

  Correct Answer: B

• Question 229:

  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?

  A. Fail

  B. Pass

  C. 50.5

  D. . (missing numeric value)

  Correct Answer: C

• Question 230:

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

  A. It prevents SAS from loading a new record when the end of the current record is reached.

  B. It enables SAS to scan the input data records until the character string that is specified in the @`character-string' expression is round.

  C. 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.

  D. 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 statement.

  Correct Answer: A