SAS Institute A00-202 Online Practice Questions and Exam Preparation

SAS Institute A00-202 Online Questions & Answers

• Question 11:

  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
  C. WARM

• Question 12:

  The following SAS program is submitted:

  %let a = cat;

  %macro animal(a = frog);

  %let a = bird;

  %mend;

  %animal(a = pig)

  %put a is anda;

  Which one of the following is written to the SAS log?

  A. a is anda
  B. a is cat
  C. a is pig
  D. a is bird
  B. a is cat

• Question 13:

  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;
  B. data two; set one; totrev = sum(price * quantity); if totrev > 1000; totcost = sum(fixed,variable); profit = sum(totrev,otcost); run;

• Question 14:

  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
  D. andSYSERR

• Question 15:

  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;
  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;

• Question 16:

  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?

  A. 1
  B. 2
  C. 1.8
  D. null
  A. 1

• Question 17:

  Which one of the following displays the definition of a stored SQL procedure view in the SAS log?

  A. ECHOVIEW option
  B. EXPANDVIEW option
  C. VALIDATE VIEW statement
  D. DESCRIBE VIEW statement
  D. DESCRIBE VIEW statement

• Question 18:

  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
  A. MPRINT

• Question 19:

  The following SAS program is submitted:

  data two;

  y = '2';

  run;

  %let x = 10;

  %let var = y;

  data one;

  set two (keep = andvar);

  z = andvar * andx;

  run;

  Which one of the following is the value of the variable Z when the program finishes execution?

  A. _ERROR_
  B. 20 (as a numeric)
  C. 20 (as a character)
  D. . (missing numeric)
  B. 20 (as a numeric)

• Question 20:

  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;
  C. data new(bufsize = 2000 bufno = 3); set temp; run;