SAS Institute SAS Institute Certifications A00-211 Questions & Answers

• Question 111:

  The following SAS program is submitted:

  data work.one;

  x = 3;

  y = 2;

  z = x ** y;

  run;

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

  A. 6

  B. 9

  C. . (missing numeric value)

  D. The program fails to execute due to errors.

  Correct Answer: B

• Question 112:

  The following SAS program is submitted:

  data work.company; set work.dept1(keep = jobcode) work.dept2(rename = (jcode = jobcode)); run;

  Which one of the following is the result?

  A. The variable JCODE is written to the output data set.

  B. The variable JOBCODE is written to the output data set.

  C. Neither variable JCODE nor JOBCODE is written to the output data set.

  D. The program fails to execute due to errors.

  Correct Answer: B

• Question 113:

  Which one of the following SAS statements renames two variables?

  A. set work.dept1 work.dept2(rename = (jcode = jobcode) (sal = salary));

  B. set work.dept1 work.dept2(rename = (jcode = jobcode sal = salary));

  C. set work.dept1 work.dept2(rename = jcode = jobcode sal = salary);

  D. set work.dept1 work.dept2(rename = (jcode jobcode) (sal salary));

  Correct Answer: B

• Question 114:

  The following SAS program is submitted:

  libname sasdata 'SAS-data-library';

  data test;

  set sasdata.chemists (keep = job_code);

  if job_code = 'chem3'

  then description = 'Senior Chemist';

  run;

  The variable JOB_CODE is a character variable with a length of 6 bytes.

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

  A. 6 bytes

  B. 8 bytes

  C. 14 bytes

  D. 200 bytes

  Correct Answer: C

• Question 115:

  The following SAS DATA step is submitted:

  data work.accounting; set work.department; length jobcode $ 12; run;

  The WORK.DEPARTMENT SAS data set contains a character variable named JOBCODE with a length of

  5.

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

  A. 5

  B. 8

  C. 12

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

  Correct Answer: A

• Question 116:

  A raw data file is listed below:

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

  squash 1.10

  apples 2.25

  juice 1.69

  The following SAS program is submitted using the raw data file above:

  data groceries;

  infile 'file-specification';

  input item $ cost;

  run;

  Which one of the following completes the program and produces a grand total for all COST values?

  A. grandtot = sum cost;

  B. grandtot = sum(grandtot,cost);

  C. retain grandtot 0; grandtot = sum(grandtot,cost);

  D. grandtot = sum(grandtot,cost); output grandtot

  Correct Answer: C

• Question 117:

  The following SAS program is submitted:

  data work.test;

  First = 'Ipswich, England';

  City_Country = substr(First,1,7)!!', '!!'England';

  run;

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

  A. 6

  B. 7

  C. 17

  D. 25

  Correct Answer: D

• Question 118:

  The following SAS program is submitted:

  data work.test;

  First = 'Ipswich, England';

  City = substr(First,1,7);

  City_Country = City!!', '!!'England';

  run;

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

  A. Ipswich!!

  B. Ipswich, England

  C. Ipswich, 'England'

  D. Ipswic h, England

  Correct Answer: B

• Question 119:

  Which one of the following is true of the RETAIN statement in a SAS DATA step program?

  A. It can be used to assign an initial value to _N_ .

  B. It is only valid in conjunction with a SUM function.

  C. It has no effect on variables read with the SET, MERGE and UPDATE statements.

  D. It adds the value of an expression to an accumulator variable and ignores missing values.

  Correct Answer: C

• Question 120:

  The following SAS program is submitted:

  data work.test;

  Author = 'Christie, Agatha';

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

  run;

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

  A. A

  B. C

  C. Agatha

  D. ' ' (missing character value)

  Correct Answer: A