SAS Institute SAS Institute Certifications A00-202 Questions & Answers

• Question 101:

  Which one of the following SAS procedures changes a permanent format of a variable stored in a SAS data set?

  A. MODIFY

  B. FORMAT

  C. CONTENTS

  D. DATASETS

  Correct Answer: D

• Question 102:

  Given the following SAS data set SASUSER.HIGHWAY:

  SASUSER.HIGHWAY

  STEERING SEATBELT SPEED STATUS COUNT

  ------------------------------------------------------------------------ absent no 0-29 serious 31

  absent no 0-29 not 1419

  absent no 30-49 serious 191

  absent no 30-49 not 2004

  absent no 50+ serious 216

  The following SAS program is submitted:

  %macro highway;

  proc sql noprint;

  select count(distinct status)

  into :numgrp

  from sasuser.highway;

  %let numgrp = andnumgrp;

  select distinct status

  into :group1-:groupandnumgrp

  from sasuser.highway;

  quit;

  %do i = 1 %to andnumgrp;

  proc print data = sasuser.highway;

  where status = "andandgroupandi" ;

  run;

  %end;

  %mend;

  %highway

  How many reports are produced by the above program?

  A. 0

  B. 1

  C. 2

  D. 5

  Correct Answer: C

• Question 103:

  The SAS data set ONE has a variable X on which an index has been created. The data sets ONE and THREE are sorted by X. Which one of the following SAS programs uses the index to select observations from the data set ONE?

  A. data two; set three; set one key = X; run;

  B. data two; set three key = X; set one; run;

  C. data two; set one; set three key = X; run;

  D. data two; set three; set one (key = X); run;

  Correct Answer: A

• Question 104:

  Given the following SAS data set ONE:

  ONE REP AREA COST

  SMITH NORTH 100 SMITH SOUTH 200 JONES EAST 100 SMITH NORTH 300 JONES WEST 100 JONES NORTH 200 JONES NORTH 400 SMITH NORTH 400 JONES WEST 100 JONES WEST 300

  The following SAS program is submitted: proc sql;

  select rep, area, count(*) as TOTAL

  from one group by rep, area;

  quit;

  Which one of the following reports is generated?

  A. REP AREA COUNT

  JONES EAST 100

  JONES NORTH 600

  JONES WEST 500

  SMITH NORTH 800

  SMITH SOUTH 200

  B. REP AREA TOTAL

  JONES EAST 100

  JONES NORTH 600

  JONES WEST 500

  SMITH NORTH 800

  SMITH SOUTH 200

  C. REP AREA TOTAL

  JONES EAST 1

  JONES NORTH 2

  JONES WEST 3

  SMITH NORTH 3

  JONES WEST 3

  SMITH NORTH 3

  SMITH SOUTH 1

  D. REP AREA TOTAL

  JONES EAST 1

  JONES NORTH 2

  JONES WEST 3

  SMITH NORTH 3

  SMITH SOUTH 1

  SMITH NORTH 3

  SMITH SOUTH 1

  Correct Answer: D

• Question 105:

  Given the following SAS data sets ONE and TWO:

  ONE TWO NUM CHAR1 NUM CHAR2

  1 A 2 X

  2 B 3 Y

  4 D 5 V

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

  data three;

  set one two;

  run;

  THREE

  NUM CHAR1 CHAR2

  1 A 2 B 4 D 2 X 3 Y 5 V

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

  A. proc sql; create table three as select * from one outer union corr select * from two; quit;

  B. proc sql; create table three as select * from one outer union select * from two; quit;

  C. proc sql; create table three as select * from one outer union select * quit;

  D. proc sql; create table three as select * from one union corr select * from two; quit;

  Correct Answer: A

• Question 106:

  Which one of the following automatic SAS macro variables contains the return code from a previously executed step?

  A. andRC

  B. andERR

  C. andSYSRC

  D. andSYSERR

  Correct Answer: D

• Question 107:

  Given the following SAS data set ONE:

  ONE COUNTRY CITY VISIT

  USA BOSTON 10

  UK LONDON 5

  USA DALLAS 10

  UK MARLOW 10

  USA BOSTON 20

  UK LONDON 15

  USA DALLAS 10

  The following SAS program is submitted:

  proc sql;

  select country, city, sum(visit) as TOTAL

  from one group by country, city

  order by country, total desc;

  quit;

  Which one of the following reports is generated?

  A. COUNTRY CITY TOTAL

  UK MARLOW 10

  UK LONDON 20

  USA BOSTON 50

  USA DALLAS 20

  B. COUNTRY CITY TOTAL

  UK LONDON 20

  UK MARLOW 10

  USA BOSTON 50

  USA DALLAS 20

  C. COUNTRY CITY TOTAL

  USA BOSTON 50 D. COUNTRY CITY TOTAL

  UK MARLOW 10

  UK LONDON 20

  USA DALLAS 20

  USA BOSTON 50

  Correct Answer: B

• Question 108:

  Given the following SAS data set ONE:

  ONE GROUP SUM

  A 765

  B 123

  C 564

  The following SAS program is submitted:

  data _null_;

  set one;

  call symput(group,sum);

  run;

  Which one of the following is the result when the program finishes execution?

  A. Macro variable C has a value of 564.

  B. Macro variable C has a value of 1452.

  C. Macro variable GROUP has a value of 564.

  D. Macro variable GROUP has a value of 1452.

  Correct Answer: A

• Question 109:

  The SAS data set ONE consists of five million observations and has 25 variables. Which one of the following SAS programs successfully creates three new variables TOTREV, TOTCOST, and PROFIT and requires the least CPU time to be processed?

  A. data two; set one; totrev = sum(price * quantity); totcost = sum(fixed,variable); profit = sum(totrev,otcost); if totrev > 1000; run;

  B. data two; set one; totrev = sum(price * quantity); if totrev > 1000; totcost = sum(fixed,variable); profit = sum(totrev,otcost); run;

  C. data two; set one; totrev = sum(price * quantity); where totrev > 1000; totcost = sum(fixed,variable); profit = sum(totrev,otcost); run;

  D. data two; set one; where totrev > 1000; totrev = sum(price * quantity); totcost = sum(fixed,variable); profit = sum(totrev,otcost); run;

  Correct Answer: B

• Question 110:

  The following SAS program is submitted:

  %let value = 9;

  %let value2 = 5;

  %let newval = %eval(andvalue / andvalue2);

  Which one of the following is the resulting value of the macro variable NEWVAL?

  B. 2

  C. 1.8

  D. null

  Correct Answer: A