SAS Institute SAS Institute Certifications A00-201 Questions & Answers

• Question 111:

  The following SAS program is submitted:

  data work.empsalary;

  set work.people (in = inemp)

  work.money (in = insal):

  if insal and inemp;

  run;

  The SAS data set WORK.PEOPLE has 5 observations, and the data set WORK.MONEY has 7 observations.

  How many observations will the data set WORK.EMPSALARY contain?

  A. 0

  B. 5

  C. 7

  D. 12

  Correct Answer: A

• Question 112:

  The following SAS program is submitted;

  data work.test;

  First = `lpswich, 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. lpswich!!

  B. lpswich, England

  C. lpswich, `England'

  D. lpswich , England

  Correct Answer: D

• Question 113:

  The following SAS program is submitted:

  data numrecords;

  infile `file-specification';

  input@1 patient $15.

  relative$ 16-26@;

  if relative = `children' then

  input diagnosis $15. @;

  else if relative = `parents' then

  input @28 doctor $15.

  clinic $ 44-53

  @54diagnosis $15. @;

  input age;

  run;

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

  A. 1

  B. 2

  C. 3

  D. 4

  Correct Answer: A

• Question 114:

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

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

  24613 $25.31

  The following SAS program is submitted:

  data inventory; infile `product; input idnum 5. @10 price; run;

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

  A. 25.31

  B. $25.31

  C. . (missing numeric value)

  D. No value is stored as the program fails to execute due to errors.

  Correct Answer: C

• Question 115:

  The following SAS program is submitted:

  data work.test;

  array agents{4}$ 12 sales1 - sales4

  run;

  Which one of the following represents the variables that are contained in the output data set?

  A. SALES1, SALES2, SALES3, SALES4

  B. AGENTS1, AGENTS2, AGENTS3, AGENTS4

  C. None, the DATA step fails because the ARRAY statement can reference only numeric data.

  D. None, the DATA step fails because the ARRAY statement can reference only pre-existing variables.

  Correct Answer: A

• Question 116:

  The following SAS program is submitted:

  proc format

  value score 1 - 50 = `Fail'

  51 - 100 = `Pass';

  run;

  proc report data = work.courses nowd;

  column exam;

  define exam / display format = score.;

  run;

  The variable EXAM has a value of 50.5.

  How will the EXAM variable value be displayed in the REPORT procedure output?

  A. Fail

  B. Pass

  C. 50.5

  D. .(missing numeric value)

  Correct Answer: C

• Question 117:

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

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

  The following SAS program is submitted:

  data test;

  infile `calendar';

  input@1 date mmddyy10.;

  if date = `01012000'd then event = `January 1st;

  run;

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

  A. 01012000

  B. January 1st

  C. .(missing numeric value)

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

  Correct Answer: D

• Question 118:

  The following SAS program is submitted:

  data work.report; set work.sales_info; if qtr(sales_date) ge 3; run;

  The SAS data set WORK.SALES_INFO has one observation for each month in the year 2000 and the variable SALES_DATE which contains a SAS date value for each of the twelve months.

  How many of the original twelve observations in WORKSALES_INFO are written to the WORKREPORT data set?

  A. 2

  B. 3

  C. 6

  D. 9

  Correct Answer: C

• Question 119:

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

  Which one of the following statements is true regarding the name of a SAS array?

  A. It is saved with the data set.

  B. It can be used in procedures.

  C. It exists only for the duration of the DATA step.

  D. It can be the same as the name of a variable in the data set.

  Correct Answer: C