SASInstitute SAS Institute Systems Certification A00-202 Questions & Answers

• Question 31:

  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 left join two

  on one.year = two.year;

  quit;

  Which one of the following reports is generated?

  A. YEAR QTR BUDGET SALES 2001 3 500 .

  B. YEAR QTR BUDGET SALES

  2001 4 400 300

  2002 1 700 600

  C. YEAR QTR BUDGET SALES

  2001 3 500 .

  2001 4 400 300

  2002 1 700 600

  D. YEAR QTR BUDGET SALES

  2001 3 500 300

  2001 4 400 300

  2002 1 700 600

  Correct Answer: D

• Question 32:

  Given the following SAS data set ONE:

  ONE COUNTRY CITY VISIT

  USA BOSTON 10

  UK LONDON 5

  USA DALLAS

  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

  USA DALLAS 20

  UK LONDON 20

  UK MARLOW 10

  D. COUNTRY CITY TOTAL

  UK MARLOW 10

  UK LONDON 20

  USA DALLAS 20

  USA BOSTON 50

  Correct Answer: B

• Question 33:

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

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

  The following SAS code is submitted:

  %macro houses(dsn = houses,sub = RANCH);

  data anddsn;

  set sasuser.houses;

  if style = "andsub";

  run;

  %mend;

  %houses(sub = SPLIT)

  %houses(dsn = ranch)

  %houses(sub = TWOSTORY)

  Which one of the following is the value of the automatic macro variable SYSLAST?

  A. work.ranch

  B. work.houses

  C. WORK.RANCH

  D. WORK.HOUSES

  Correct Answer: D

• Question 36:

  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;

  Correct Answer: D

• Question 37:

  The following SAS program is submitted:

  proc contents data = testdata.one;

  run;

  Which one of the following SQL statements produces similar information about the column attributes as the above CONTENTS procedure?

  A. proc sql; show testdata.one; quit;

  B. proc sql; describe testdata.one; quit;

  C. proc sql; show table testdata.one; quit;

  D. proc sql; describe table testdata.one; quit;

  Correct Answer: D

• Question 38:

  The following SAS program is submitted:

  data one;

  do i = 1 to 10;

  ptobs = ceil(ranuni(0) * totobs);

  set temp point = ptobs

  nobs = totobs;

  output;

  end;

  stop;

  run;

  The SAS data set TEMP contains 2,500,000 observations. Which one of the following represents the possible values for PTOBS?

  A. any integer between 1 and 10

  B. any real number between 0 and 1

  C. any integer between 1 and 2,500,000

  D. any real number between 1 and 2,500,000

  Correct Answer: C

• Question 39:

  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

  Correct Answer: C

• Question 40:

  The following SAS program is submitted:

  %let var = chicago, 1;

  data a;

  var = 'new york, 2';

  newvar = %scan(andvar,2,%str());

  run;

  Which one of the following explains why the program fails to execute?

  A. The %STR() is invalid syntax.

  B. The %SCAN function does not exist.

  C. The %SCAN function has too many arguments.

  D. The macro variable VAR does not get created properly.

  Correct Answer: C