SAS Institute SAS Institute Certifications A00-201 Questions & Answers

• Question 51:

  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 named WORK.SALARY contains 10 observations for each department, currently ordered by DEPARTMENT.

  Which one of the following is true regarding the program above?

  A. The BY statement in the DATA step causes a syntax error.

  B. FIRST.DEPARTMENT and LAST DEPARTMENT are variables in the WORK.TOTAL data set.

  C. The values of the variable PAYROLL represent the total for each department in the WORK.SALARY data set.

  D. The values of the variable PAYROLL represent a total for all values of WAGERATE in the WORK.SALARY data set.

  Correct Answer: C

• Question 52:

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

  The following SAS program is submitted:

  data work.month; d ate = 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 54:

  The following SAS program is submitted:

  data work.new;

  length word $7;

  amount = 7;

  if amount = 5 then word = `CAT';

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

  else word = `NONE!!!';

  amount = 5;

  run;

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

  A. amount word 5 DOG

  B. amount word 5 CAT

  C. amount word 7 DOG

  D. amount word 7 " " (missing character value)

  Correct Answer: A

• Question 55:

  The SAS data set named WORK.TEST is listed below:

  Which one of the following SAS programs created this data set?

  A. data work.test; capacity= 150; if 100 le capacity le 200 then airplanetype = `Large' and staff = 10; else airplanetype = `Small' and staff = 5; run;

  B. data work.test capacity= 150; if 100 le capacity le 200 then do; airplanetype = `Large'; staff= 10; end; else do; airplanetype = `Small'; staff = 5; end; run;

  C. data work.test; capacity = 150; if 100 le capacity le 200 then do; airplanetype = `Large'; staff = 10; else do; airplanetype = `Small'; airplanetype = `Small'; staff = 5; end; run;

  D. data work.test;D.data work.test capacity = 150; if 100 le capacity le 200 then; airplanetype = `Small'; airplanetype = `Small'; staff = 5; else; airplanetype = `Large'; airplanetype = `Large'; staff= 10; run;

  Correct Answer: B

• Question 56:

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

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

  $1,234

  The following SAS program is submitted:

  data test;

  infile `amount;

  input @1 salary 6

  if _error_ then description = `Problems';

  else description = `No Problems';

  run;

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

  A. Problems

  B. No Problems

  C. `` (missing character value)

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

  Correct Answer: A

• Question 57:

  A raw data file is listed below:

  1901 2 1905 1 1910 6 1925 . 1941 1

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

  data coins; infile `file-specification'; input year quantity; run;

  Which one of the following completes the program and produces a non-missing value for the variable TOTQUANTITY in the last observation of the output data set?

  A. totquantity + quantity;

  B. totquantity = sum(totquantity + quantity);

  C. totquantity 0; sum totquantity;

  D. retain totquantity 0; totquantity = totquantity + quantity;

  Correct Answer: A

• Question 58:

  The SAS data set EMPLOYEE_INFO is listed below:

  IDNUMBER Expenses 2542 100.00 3612 133.15 2198 234.34 2198 111.12

  The following SAS program is submitted:

  proc sort data = employee_info; run;

  Which one of the following BY statements completes the program and sorts the data sequentially by ascending expense values within each ascending IDNUMBER value?

  A. by Expenses IDNumber;

  B. by IDNumber Expenses;

  C. by ascending (IDNumber Expenses);

  D. by ascending IDNumber ascending Expenses;

  Correct Answer: B

• Question 59:

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

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

  Janice 10

  Henri 11

  Michael 11

  Susan 12

  The following SAS program is submitted:

  data group;

  infile `team';

  input name $15. age 2.;

  file `file-specification';

  put name $15. +5 age 2.;

  run;

  Which one of the following describes the output created?

  A. a raw data file only

  B. a SAS data set named GROUP only

  C. a SAS data set named GROUP and a raw data file

  D. No output is generated as the program fails to execute due to errors.

  Correct Answer: C

• Question 60:

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