SAS Institute SAS Institute Certifications A00-202 Questions & Answers

• Question 91:

  Which one of the following statements is true regarding a SAS DATA step view?

  A. It allows write capabilities.

  B. It contains global statements.

  C. It contains data and a descriptor portion.

  D. It contains a partially compiled DATA step.

  Correct Answer: D

• Question 92:

  Given the following SAS data sets ONE and TWO:

  ONE TWO

  OBS COMMON X OBS COMMON Y

  --------------------------- ----------------------------- 1 A 10 1 A 1

  2 A 13 2 A 3

  3 A 14 3 B 4

  4 B 9 4 B 2

  5 C 8 5 C 5

  6 C 14

  The following SAS DATA step is submitted:

  data combine;

  merge one two;

  by common;

  run;

  Which one of the following represents the data values stored in data set COMBINE?

  A. OBS COMMON X Y

  1 A 10 1

  2 A 13 3

  3 A 14 3

  4 B 9 4

  5 B 9 2

  6 C 8 5

  7 C 14 5

  B. OBS COMMON X Y

  1 A 10 1

  2 A 13 3

  3 B 9 4

  4 C 8 5

  C. OBS COMMON X Y

  1 A 10 1

  2 A 13 3

  3 B 14 4

  4 B 9 2

  5 C 8 5

  D. OBS COMMON X Y

  1 A 10 1

  2 A 13 1

  3 A 14 1

  4 A 10 3

  5 A 13 3

  6 A 14 3

  7 B 9 4

  8 B 9 2

  9 C 8 5

  10 C 14 5

  Correct Answer: A

• Question 93:

  Given the following SAS data sets ONE and TWO:

  ONE TWO NUM CHAR1 NUM CHAR 2

  1 A1 2 X1

  1 A2 2 X 2

  2 B1 3 Y

  2 B2 5 V

  4 D

  The following SAS program is submitted creating the output table THREE:

  proc sql;

  create table three as

  select one.num, char1, char2

  from one, two

  where one.num = two.num;

  quit;

  THREE

  NUM CHAR1 CHAR2

  2 B1 X1 2 B1 X 2 2 B2 X 1 2 B2 X 2

  Which one of the following DATA step programs creates an equivalent SAS data set THREE?

  A. data three; merge one two; by num; run;

  B. data three; set one; set two; by num; run; merge one two; by num; run;

  C. data three; set one; set two; by num; run; by num; run;

  D. data three; set one; do i = 1 to numobs; set two(rename = (num = num2)) point = i nobs = numobs; if num2 = num then output; end; drop num2; run;

  Correct Answer: D

• Question 94:

  The following SAS program is submitted:

  %macro execute;

  proc print data = sasuser.houses;

  run;

  %end;

  %mend;

  Which of the following completes the above program so that it executes on Tuesday?

  A. %if andsysday = Tuesday %then %do;

  B. %if andsysday = 'Tuesday' %then %do;

  C. %if "andsysday" = Tuesday %then %do;

  D. %if 'andsysday' = 'Tuesday' %then %do;

  Correct Answer: A

• Question 95:

  The following SAS FORMAT procedure is submitted:

  proc format lib = sasuser;

  value tempc low < 0 = 'BELOW FREEZING'

  0 < 5 = 'COLD'

  5 < 10 = 'MILD'

  10 < 15 = 'WARM'

  15 high = 'HOT';

  run;

  How is the value 10 displayed when the format TEMPC is applied?

  A. 10

  B. MILD

  C. WARM

  D. BELOW FREEZING

  Correct Answer: C

• Question 96:

  Which one of the following SAS programs uses the most amount of memory resources for output buffers?

  A. data new(bufsize = 1000 bufno = 5); set temp; run;

  B. data new(bufsize = 1000 bufno = 2); set temp; run;

  C. data new(bufsize = 2000 bufno = 3); set temp; run;

  D. data new(bufsize = 4000 bufno = 1); set temp; run;

  Correct Answer: C

• Question 97:

  Which one of the following SAS SORT procedure options eliminates identical consecutive observations?

  A. NODUP

  B. UNIQUE

  C. DISTINCT

  D. NODUPKEY

  Correct Answer: A

• Question 98:

  The following SAS program is submitted:

  data temp;

  array points{3,2}_temporary_ (10,20,30,40,50,60); score = points{2,1}

  run;

  Which one of the following is the value of the variable SCORE in the data set TEMP?

  A. 10

  B. 20

  C. 30

  D. 40

  Correct Answer: C

• Question 99:

  Text is sent to the SAS compiler as a result of macro execution. Which one of the following SAS System options writes that text to the log?

  A. MPRINT

  B. MLOGIC

  C. MSOURCE

  D. SOURCE2

  Correct Answer: A

• Question 100:

  Given the following SAS data set ONE:

  ONE

  CATEGORY AGE SALARY BONUS

  --------------------------------------------------- M 28 200 .

  M 25 100 10

  F 100 50

  F 25 200 10

  The following SAS program is submitted:

  proc sql;

  create table two as

  select category, salary + bonus as EARNINGS

  from one; quit;

  Which one of the following represents the data values stored in the data set TWO?

  A. CATEGORY EARNINGS

  M 200

  M 110

  F 150

  F 210

  B. CATEGORY EARNINGS

  M .

  M 110

  F 150

  F 210

  C. CATEGORY SALARY BONUS EARNINGS --------------------------------------------------------------- M 200 . 200 M 100 10 110 F 100 50 150 F 200 10 210

  D. CATEGORY SALARY BONUS EARNINGS

  M 200 . .

  M 100 10 110

  M 200 . 200

  M 100 10 110

  F 100 50 150

  F 200 10 210

  Correct Answer: B