SASInstitute SAS Institute Systems Certification A00-201 Questions & Answers

• Question 131:

  The following SAS program is submitted:

  data work.new;

  length word $7;

  amount = 4;

  if amount = 4 then word = `FOUR';

  else if amount = 7 then word = `SEVEN';

  else word = `NONE!!!';

  amount = 7;

  run;

  Which one of the following represents the values of the AMOUNT and WORD variables?

  A. amount word 7 FOUR

  B. amount word 7 FOUR

  C. amount word 4 FOUR

  D. amount word 4 " "

  Correct Answer: A

• Question 132:

  The following SAS program is submitted:

  data work.flights;

  destination = `CPH';

  select(destination);

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

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

  otherwise;

  end;

  run;

  Which one of the following is the value of the CITY variable?

  A. London

  B. Copenh

  C. Copenhagen

  D. ` `(missing character value)

  Correct Answer: B

• Question 133:

  The following SAS program is submitted and reads 100 records from a raw data file:

  data work.total;

  infile `file-specification' end = eof;

  input name $ salary;

  totsal + salary;

  run;

  Which one of the following IF statements writes the last observation to the output data set?

  A. if end = 0;

  B. if eof = 0;

  C. if end = 1;

  D. if eof = 1;

  Correct Answer: D

• Question 134:

  The following SAS program is submitted;

  data work.month; date = put('13mar2000'd,ddmmw10.); 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, 10bytes

  C. character, 8 bytes

  D. character, 10 bytes

  Correct Answer: D

• Question 135:

  The SAS data set QTR 1_REVENUE is listed below:

  The following SAS program is submitted:

  proc sort data = qtrl_revenue;

  by destination descending revenue;

  run;

  Which one of the following represents the first observation in the output data set?

  destination revenue YYZ 53634 FRA 62129 FRA 75962 RDU 76254 YYZ 82174

  A. destination revenue YYZ 82174

  B. destination revenue YYZ 53634

  C. destination revenue FRA 62129

  D. destination revenue FRA 75962

  Correct Answer: D

• Question 136:

  The following SAS program is submitted:

  data work.total;

  set work.salary(keep = department wagerate);

  by department;

  if first.department then payroll = 0;

  payroll + wagerate;

  if last.department;

  run;

  The SAS data set WORK.SALARY, currently ordered by DEPARTMENT, contains 100 observations for each of 5 departments.

  Which one of the following represents how many observations the WORK.TOTAL data set contains?

  A. 5

  B. 20

  C. 100

  D. 500

  Correct Answer: A

• Question 137:

  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 138:

  The following SAS program is submitted:

  libname sasdata `SAS-data-library';

  data test;

  set sasdata.chemists;

  if jobcode = `chem3'

  then description = `Senior Chemist';

  else description = `Unknown';

  run;

  A value for the variable JOBCODE is listed below:

  JOBCODE

  CHEM3

  Which one of the following values does the variable DESCRIPTION contain?

  A. chem3

  B. Unknown

  C. Senior Chemist

  D. ` `(missing character value)

  Correct Answer: B

• Question 139:

  Which one of the following is true when SAS encounters a data error in a DATA step?

  A. The DATA step stops executing at the point of the error, and no SAS data set is created.

  B. A note is written to the SAS log explaining the error, and the DATA step continues to execute.

  C. A note appears in the SAS log that the incorrect data record was saved to a separate SAS file for further examination.

  D. The DATA step stops executing at the point of the error, and the resulting DATA set contains observations up to that point.

  Correct Answer: B

• Question 140:

  The following SAS program is submitted:

  proc means data = sasuser.houses std mean max; var sqfeet run;

  Which one of the following is needed to display the standard deviation with only two decimal places?

  A. Add the option MAXDEC = 2 to the MEANS procedure statement.

  B. Add the statement MAXDEC = 7.2; in the MEANS procedure step.

  C. Add the statement FORMAT STD 7.2; in the MEANS procedure step.

  D. Add the option FORMAT = 7.2 option to the MEANS procedure statement.

  Correct Answer: A