SAS Institute SAS Institute Certifications A00-211 Questions & Answers

• Question 121:

  The following SAS program is submitted:

  data work.test;

  Title = 'A Tale of Two Cities, Charles J. Dickens';

  Word = scan(title,3,' ,');

  run;

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

  A. T

  B. of

  C. Dickens

  D. ' ' (missing character value)

  Correct Answer: D

• Question 122:

  The following SAS program is submitted:

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

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

  A. 2000

  B. '2000'

  C. . (missing numeric value)

  D. ' ' (missing character value)

  Correct Answer: A

• Question 123:

  The following SAS program is submitted:

  data work.test;

  Author = 'Agatha Christie';

  First = substr(scan(author,1,' ,'),1,1);

  run;

  Which one of the following is the length of the variable FIRST in the output data set?

  A. 1

  B. 6

  C. 15

  D. 200

  Correct Answer: D

• Question 124:

  The following SAS program is submitted:

  data work.month; date = input('13mar2000',date9.); run;

  Which one of the following represents the type and length of the variable DATE in the output data set?

  A. numeric, 8 bytes

  B. numeric, 9 bytes

  C. character, 8 bytes

  D. character, 9 bytes

  Correct Answer: A

• Question 125:

  The following SAS program is submitted:

  data work.products;

  Product_Number = 5461;

  Item = '1001';

  Item_Reference = Item'/'Product_Number;

  run;

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

  A. 1001/5461

  B. 1001/ 5461

  C. . (missing numeric value)

  D. The value can not be determined as the program fails to execute due to errors.

  Correct Answer: D

• Question 126:

  The following SAS program is submitted:

  data work.month; date = put('13mar2000'd,ddmmyy10.); run;

  Which one of the following represents the type and length of the variable DATE in the output data set?

  A. numeric, 8 bytes

  B. numeric, 10 bytes

  C. character, 8 bytes

  D. character, 10 bytes

  Correct Answer: D

• Question 127:

  The following SAS program is submitted:

  data work.pieces;

  do while (n lt 6);

  n + 1;

  end;

  run;

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

  A. 4

  B. 5

  C. 6

  D. 7

  Correct Answer: C

• Question 128:

  A raw data record is listed below:

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

  1999/10/25

  The following SAS program is submitted:

  data projectduration;

  infile 'file-specification';

  input date $ 1 - 10;

  run;

  Which one of the following statements completes the program above and computes the duration of the

  project in days as of today's date?

  A. duration = today( ) - put(date,ddmmyy10.);

  B. duration = today( ) - put(date,yymmdd10.);

  C. duration = today( ) - input(date,ddmmyy10.);

  D. duration = today( ) - input(date,yymmdd10.);

  Correct Answer: D

• Question 129:

  The following SAS program is submitted:

  data work.clients;

  calls = 6;

  do while (calls le 6);

  calls + 1;

  end;

  run;

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

  A. 4

  B. 5

  C. 6

  D. 7

  Correct Answer: D

• Question 130:

  The SAS data set BANKS is listed below:

  BANKS

  name rate

  FirstCapital 0.0718

  DirectBank 0.0721

  VirtualDirect 0.0728

  The following SAS program is submitted:

  data newbank;

  do year = 1 to 3;

  set banks;

  capital + 5000;

  end;

  run;

  Which one of the following represents how many observations and variables will exist in the SAS data set

  NEWBANK?

  A. 0 observations and 0 variables

  B. 1 observations and 4 variables

  C. 3 observations and 3 variables

  D. 9 observations and 2 variables

  Correct Answer: B