SAS Institute A00-202 Online Practice Questions and Exam Preparation

SAS Institute A00-202 Online Questions & Answers

• Question 31:

  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
  C. both user and system defined macro variables

• Question 32:

  Given the following SAS data sets ONE and TWO:

  ONE TWO

  YEAR QTR BUDGET YEAR QTR SALES

  ------------------------------ ----------------------------- 2001 3 500 2001 4 300

  2001 4 400 2002 1 600

  2002 1 700

  The following SAS program is submitted:

  proc sql;

  select one.*, sales

  from one, two

  where one.year = two.year;

  quit;

  Which one of the following reports is generated?

  A. YEAR QTR BUDGET SALES 2001 4 400 300 2002 1 700 600
  B. YEAR QTR BUDGET SALES 2001 3 500 . 2001 4 400 300 2002 1 700 600
  C. YEAR QTR BUDGET SALES 2001 3 500 300 2001 4 400 300 2002 1 700 600
  D. YEAR QTR BUDGET SALES 2001 3 500 300 2001 4 400 300 2002 1 700 300 2001 3 500 600 2001 4 400 600 2002 1 700 600
  C. YEAR QTR BUDGET SALES 2001 3 500 300 2001 4 400 300 2002 1 700 600

• Question 33:

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

  Which one of the following programs contains a syntax error?

  A. proc sql; select product.*, cost.unitcost, sales.quantity from product p, cost c, sales s where p.item = c.item and
  B. item = s.item; quit;
  C. proc sql; select product.*, cost.unitcost, sales.quantity from product, cost, sales where product.item = cost.item and product.item = sales.item; quit;
  D. proc sql; select p.*, c.unitcost, s.quantity from product as p, cost as c, sales as s where p.item = c.item and
  E. item = s.item; quit;
  F. proc sql; select p.*, c.unitcost, s.quantity from product, cost, sales where product.item = cost.item and product.item = sales.item; quit;
  D. proc sql; select p.*, c.unitcost, s.quantity from product as p, cost as c, sales as s where p.item = c.item and

• Question 35:

  The following SAS program is submitted:

  data temp;

  array points{2,3}_temporary_;

  run;

  Which one of the following is the maximum number of elements that are stored?

  A. 2
  B. 3
  C. 5
  D. 6
  D. 6

• Question 36:

  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_
  C. new, X, and COL1

• Question 37:

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

  A. NODUP
  B. UNIQUE
  C. DISTINCT
  D. NODUPKEY
  A. NODUP

• Question 38:

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

• Question 39:

  Given the following SAS statement:

  %let idcode = Prod567;

  Which one of the following statements stores the value 567 in the macro variable CODENUM?

  A. %let codenum = substr(andidcode,length(andidcode)-2);
  B. %let codenum = substr(andidcode,length(andidcode)-3);
  C. %let codenum = %substr(andidcode,%length(andidcode)-2);
  D. %let codenum = %substr(andidcode,%length(andidcode)-3);
  C. %let codenum = %substr(andidcode,%length(andidcode)-2);

• Question 40:

  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 400 50

  The following SQL program is submitted:

  proc sql;

  create table two as

  select distinct age

  from one

  where age < 33;

  quit;

  How many rows are written to the SAS data set TWO?

  A. 3
  B. 4
  C. 5
  D. 6
  A. 3