SASInstitute SAS Institute Systems Certification A00-202 Questions & Answers

• Question 21:

  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;C.proc sql; create table three as select * from one union select * from two; quit;

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

  Correct Answer: A

• Question 22:

  Which one of the following statements about compressed SAS data sets is always true?

  A. Each observation is treated as a single string of bytes.

  B. Each observation occupies the same number of bytes.

  C. An updated observation is stored in its original location.

  D. New observations are added to the end of the SAS data set.

  Correct Answer: A

• Question 23:

  Given the following SAS data sets ONE and TWO:

  ONE TWO NUM CHAR1 NUM CHAR2

  1 A1 2 X1

  1 A2 2 X2

  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 X2 2 B2 X1 2 B2 X2

  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;

  C. data three;C.data three; merge one (in = in1) two (in = in2); by num;

  if in1 and in2;

  run;

  D. data three;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 24:

  Given the following SAS data set ONE:

  ONE LEVEL AGE

  1 10

  2 20

  3 20

  2 10

  1 10

  2 30

  3 10

  2 20

  3 30

  1 10

  The following SAS program is submitted:

  proc sql;

  select level, max(age) as MAX

  from one

  group by level

  having max(age) > (select avg(age) from one);

  quit;

  Which one of the following reports is generated?

  A. LEVEL AGE

  2 20

  3 20

  B. LEVEL AGE

  2 30

  3 30

  C. LEVEL MAX

  2 20

  3 30

  D. LEVEL MAX

  2 30

  3 30

  Correct Answer: D

• Question 25:

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

  Given the following SAS data set ONE:

  ONE

  CATEGORY AGE SALARY BONUS

  ------------------------------------------------------- M 28 200 20

  M 25 100 10

  M 28 300 10

  M 33 300 30

  F 18 100 50

  F 25 200 10

  F 35 50

  The following SAS program is submitted:

  proc sql;

  select distinct category,

  sum(sum(salary,bonus)) as EARNINGS

  from one

  where age < 30

  group by category

  having calculated EARNINGS < 500;

  quit;

  Which one of the following reports will be generated?

  A. CATEGORY EARNINGS

  F 360

  B. CATEGORY EARNINGS

  M 640

  F 360

  C. CATEGORY EARNINGS F 150

  F 210

  D. CATEGORY EARNINGS M 220 M 110 M 310 F 150 F 210

  Correct Answer: A

• Question 27:

  Which one of the following is the purpose of the IDXNAME= data set option?

  A. It instructs SAS to name and store a specific index.

  B. It instructs SAS to store an index in a particular location.

  C. It instructs SAS to use a specific index for WHERE processing.

  D. It instructs SAS to use any available index for WHERE processing.

  Correct Answer: C

• Question 28:

  The SAS data set ONE contains the variables X, Y, Z, and W.

  The following SAS program is submitted:

  proc transpose data = one

  out = trans

  name = new;

  by x;

  var y;

  run;

  Which one of the following contains all the names of the columns created by the TRANSPOSE procedure?

  A. X, Y, Z, and W

  B. _NAME_, X, and Y

  C. new, X, and COL1

  D. new, X, Y, and _COL1_

  Correct Answer: C

• Question 29:

  Which of the following statement(s) in the DATASETS procedure alters the name of a SAS data set stored in a SAS data library?

  A. RENAME statement only

  B. CHANGE statement only

  C. MODIFY and RENAME statements

  D. MODIFY and CHANGE statements

  Correct Answer: B

• Question 30:

  The DICTIONARY.MACROS table stores information about which of the following?

  A. user defined macro variables only

  B. system defined macro variables only

  C. both user and system defined macro variables

  D. macros stored in the autocall macro library only

  Correct Answer: C