SAS Institute SAS Institute Certifications A00-211 Questions & Answers

• Question 141:

  The contents of the raw data file SIZE are listed below:

  --------10-------20-------30

  72 95

  The following SAS program is submitted:

  data test;

  infile 'size';

  input @1 height 2. @4 weight 2;

  run;

  Which one of the following is the value of the variable WEIGHT in the output data set?

  A. 2

  B. 72

  C. 95

  D. . (missing numeric value)

  Correct Answer: A

• Question 142:

  A SAS PRINT procedure output of the WORK.LEVELS data set is listed below:

  Obs name level 1 Frank 1 2 Joan 2 3 Sui 2 4 Jose 3 5 Burt 4 6 Kelly . 7 Juan 1 The following SAS program is submitted: data work.expertise; set work.levels; if level = . then expertise = 'Unknown'; else if level = 1 then expertise = 'Low'; else if level = 2 or 3 then expertise = 'Medium'; else expertise = 'High'; run;

  Which of the following values does the variable EXPERTISE contain?

  A. Low, Medium, and High only

  B. Low, Medium, and Unknown only

  C. Low, Medium, High, and Unknown only

  D. Low, Medium, High, Unknown, and ' ' (missing character value)

  Correct Answer: B

• Question 143:

  Given the SAS data set WORK.ONE:

  

  What value will SAS assign to Total?

  A. 3

  B. 1.6

  C. 4.8

  D. The program fails to execute due to errors.

  Correct Answer: B

• Question 144:

  A SAS program is submitted and the following SAS log is produced:

  2 data gt100;

  3 set ia.airplanes

  4 if mpg gt 100 then output;

  22 202

  ERROR: File WORK.IF.DATA does not exist.

  ERROR: File WORK.MPG.DATA does not exist.

  ERROR: File WORK.GT.DATA does not exist.

  ERROR: File WORK.THEN.DATA does not exist.

  ERROR: File WORK.OUTPUT.DATA does not exist.

  ERROR 22-322: Syntax error, expecting one of the following: a name,

  a quoted string, (, ;, END, KEY, KEYS, NOBS, OPEN, POINT, _DATA_, _LAST_, _NULL_.

  ERROR 202-322: The option or parameter is not recognized and will be ignored.

  5 run;

  The IA libref was previously assigned in this SAS session.

  Which one of the following corrects the errors in the LOG?

  A. Delete the word THEN on the IF statement.

  B. Add a semicolon at the end of the SET statement.

  C. Place quotes around the value on the IF statement.

  D. Add an END statement to conclude the IF statement

  Correct Answer: B

• Question 145:

  Consider the following data step:

  

  The computed variables City and State have their values assigned using two different methods, a RETAIN

  statement and an Assignment statement.

  Which statement regarding this program is true?

  A. The RETAIN statement is fine, but the value of City will be truncated to 8 bytes as the LENGTH statement has been omitted.

  B. Both the RETAIN and assignment statement are being used to initialize new variables and are equally efficient. Method used is a matter of programmer preference.

  C. The assignment statement is fine, but the value of City will be truncated to 8 bytes as the LENGTH statement has been omitted.

  D. City's value will be assigned one time, State's value 5 times.

  Correct Answer: D

• Question 146:

  After a SAS program is submitted, the following is written to the SAS log:

  105 data WORK.JANUARY;

  106 set WORK.ALLYEAR(keep=Product Month Quantity Cost);

  107 if Month='JAN' then output WORK.JANUARY;

  108 Sales=Cost * Quantity;

  109 drop=Month Quantity Cost;

  ERROR 22-322: Syntax error, expecting one of the following: !,

  !!, , *, **, +, -,

  , <=, <>, =, >, >=,

  AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL,

  NOTIN, OR, ^=, |, ||, ~=.

  110 run;

  What data set option could be attached to WORK.JANUARY to replace the DROP statement that

  generated the error in the log?

  A. (drop Month Quantity Cost)

  B. (drop Month, Quantity, Cost)

  C. (drop=Month, Quantity, Cost)

  D. (drop=Month Quantity Cost)

  Correct Answer: D

• Question 147:

  Given the SAS data set WORK.ORDERS:

  

  The variable order_id is numeric; customer is character; and shipped is numeric, contains a SAS date value, and is shown with the DATE9. format. A programmer would like to create a new variable, ship_note, that shows a character value with the order_id, shipped date, and customer name. For example, given the first observation ship_note would have the value "Order 9341 shipped on 02FEB2009 to Josh Martin".

  Which of the following statement will correctly create the value and assign it to ship_note?

  A. ship_note=catx(' ','Order',order_id,'shipped on',input(shipped,date9.),'to',customer);

  B. ship_note=catx(' ','Order',order_id,'shipped on',char(shipped,date9.),'to',customer);

  C. ship_note=catx(' ','Order',order_id,'shipped on',transwrd(shipped,date9.),'to',customer);

  D. ship_note=catx(' ','Order',order_id,'shipped on',put(shipped,date9.),'to',customer);

  Correct Answer: D

• Question 148:

  The following SAS program is submitted:

  

  The SAS data set WORK.SALARY is currently ordered by Gender within Department. Which inserted code will accumulate subtotals for each Gender within Department?

  A. Gender

  B. Department

  C. Gender Department

  D. Department Gender

  Correct Answer: A

• Question 149:

  Which step displays a listing of all the data sets in the WORK library?

  A. proc contents lib=WORK run;

  B. proc contents lib=WORK.all; run;

  C. proc contents data=WORK._all_; run;

  D. proc contents data=WORK _ALL_; run;

  Correct Answer: C

• Question 150:

  The following SAS program is submitted:

  data WORK.ACCOUNTING;

  set WORK.DEPARTMENT;

  length EmpId $6;

  CharEmpid=EmpId;

  run;

  If data set WORK.DEPARTMENT has a numeric variable EmpId. Which statement is true about the output

  dataset?

  A. The type of the variable CharEmpid is numeric.

  B. The type of the variable CharEmpid is unknown.

  C. The type of the variable CharEmpid is character.

  D. The program fails to execute due to errors.

  Correct Answer: D