SAS Institute SAS Institute Certifications A00-211 Questions & Answers

• Question 211:

  The following SAS program is submitted:

  data numrecords;

  infile `file specification';

  input@1 patient $15.

  relative$ 16-26@;

  if relative = `children' then

  input @54 diagnosis $15. @;

  else if relative = `parents' then

  input @28 doctor $15.

  clinic $ 44-53

  @54 diagnosis $15. @;

  input age;

  run;

  How many raw data records are read during each iteration of the DATA step execution?

  A. 1

  B. 2

  C. 3

  D. 4

  Correct Answer: B

• Question 212:

  Given the SAS data set ONE:

  Given the SAS data set WORK.ONE:

  

  The following SAS program is submitted:

  

  Which report is produced?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: B

• Question 213:

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

  105 data january;

  106 set allmonths(keep = product month num_sold cost);

  107 if month = `Jan' then output january;

  108 sales = cost * num_sold;

  109 keep = product sales;

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

  !!, and, *,**, +, -,/, <,< =, <>, =, >, ><, >=,

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

  NOTIN, OR,^=,|,II,

  110 run;

  What changes should be made to the KEEP statement to correct the errors in the LOG?

  A. keep product sales;

  B. keep product, sales;

  C. keep = product, sales;

  D. keep = (product sales);

  Correct Answer: A

• Question 214:

  The following SAS program is submitted:

  data combine; prefix='505'; middle='6465 `; end='09090'; ; run;

  Which statement successfully completes the program so that TOTAL has a value of 505-6465-09090?

  A. total = cat('-', prefix, middle, end);

  B. total = catx('-', prefix, middle, end);

  C. total = prefix !!'-'!! middle ``!!'-'!! end;

  D. total = prefix!!'-'!! left(middle)!!'-'!! end;

  Correct Answer: B

• Question 215:

  Given the contents of the raw data file TYPECOLOR:

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

  Daisyyellow

  The following SAS program is submitted:

  data flowers;

  infile `typecolor';

  input type$ 1-5+1 color$;

  run;

  What are the values of the variables TYPE and COLOR?

  A. type color daisygreen

  B. type color daisy ellow

  C. type color daisyyellow" "(missing character value)

  D. No values are stored for the TYPE and COLOR variables.

  Correct Answer: B

• Question 216:

  A user-defined format has been created using the FORMAT procedure. Where is it stored?

  A. in a SAS catalog

  B. in an external binary file

  C. in a SAS dataset in the WORK library

  D. in a SAS dataset in a permanent SAS data library

  Correct Answer: A

• Question 217:

  The following SAS program is submitted:

  data work.flights;

  destination = `cph';

  select(destination);

  when('LHR') city = `London';

  when('CPH') city = `Copenhagen';

  otherwise city = `Other';

  end;

  run;

  What is the value of the CITY variable?

  A. Other

  B. Copenh

  C. Copenhagen

  D. ``(missing character value)

  Correct Answer: A

• Question 218:

  The following SAS program is submitted:

  data work.new;

  length word $7;

  amount = 4;

  it amount = 4 then word = `FOUR';

  else if amount = 7

  then word = `SEVEN';

  else word = `NONE!!!';

  amount = 7;

  run;

  What are the values of the AMOUNT and WORD variables in SAS dataset work.new?

  A. amount word 4 FOUR

  B. amount word 4 NONE!!!

  C. amount word 7 FOUR

  D. amount word 7 SEVEN

  Correct Answer: C

• Question 219:

  The following SAS program is submitted, creating the SAS data set ONE:

  data one;

  infile `file specification';

  input num chars$;

  run;

  ONE

  NUM CHAR

  1 23 3 23 1 77 The following SAS program is submitted:

  proc print data = one; where char = 23; run;

  What is output?

  A. NUM CHAR 1 77

  B. NUM CHAR 1 23 3 23

  C. NUM CHAR 1 23 3 23 1 77

  D. No output is generated.

  Correct Answer: D

• Question 220:

  The following SAS program is submitted:

  data work.retail; cost = `20000'; total= .10* cost run;

  What is the result?

  A. The value of the variable TOTAL in the output data set is 2000. No messages are written to the SAS log.

  B. The value of the variable TOTAL in the output data set is 2000. A note that conversion has taken place is written to the SAS log.

  C. The value of the variable TOTAL in the output data set is missing. An error message is written to the SAS log.

  D. The variable TOTAL in the output data set has no value. The program fails to execute due to a syntax error.

  Correct Answer: B