SAS Institute SAS Institute Certifications A00-212 Questions & Answers

• Question 51:

  Given the SAS data sets: The following SAS program is submitted:

  

  

  What output is produced?

  A. Name

  Charlie

  Omar

  B. Name

  Omar

  Nguyen

  C. Name

  Charlie

  Nguyen

  Nguyen

  D. Name

  Charlie

  Omar

  Nguyen

  Correct Answer: A

• Question 52:

  The following SAS program is submitted:

  %let value = .5;

  %let add = 5;

  %let newval = %eval(andvalue + andadd);

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

  A. 5

  B. 5.5

  C. .5 + 5

  D. null

  Correct Answer: D

• Question 53:

  The following SAS program is submitted:

  %let first = yourname;

  %let last = first;

  %put andandandlast;

  Which one of the following is the result in the log of the %PUT statement?

  A. first

  B. andfirst

  C. yourname

  D. andyourname

  Correct Answer: C

• Question 54:

  The SAS data set WORK.TEMP is indexed on variable Id:

  

  The following SAS program is submitted:

  

  A. Stops because the data is not descending order

  B. Generates a report without a problem

  C. Stops because the data is not in ascending order

  D. Generates a report, but only if the index = USE option is turned on

  Correct Answer: A

• Question 55:

  Given the following SAS data sets ONE and TWO:

  ONE TWO NUM COUNTRY NUM CITY

  1 CANADA 3 BERLIN

  2 FRANCE 5 TOKYO

  3 GERMANY 4 BELGIUM

  5 JAPAN

  The following SAS program is submitted:

  proc sql;

  select country

  from one

  where not exists

  (select *

  from two

  where one.num = two.num);

  quit;

  Which one of the following reports is generated?

  A. COUNTRY GERMANY JAPAN

  B. COUNTRY FRANCE BELGIUM

  C. COUNTRY CANADA FRANCE BELGIUM

  D. COUNTRY CANADA FRANCE GERMANY

  Correct Answer: C

• Question 56:

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

  Given the SAS data set ONE: ONE REP COST SMITH 200 SMITH 400 JONES 100 SMITH 600 JONES 100 The following SAS program is submitted: Proc sql; Select rep, avg(cost) as AVERAGE From one Group by rep quit; The following output is desired:

  

  Which SQL procedure clause completes the program and generates the desired output?

  A. having avg(cost) < select avg(cost) from one);

  B. Having avg(cost)>(select avg(cost) from one);

  C. Where avg(cost)>(select avg(cost) from one);

  D. Where calculated average > (select avg(cost) from one);

  Correct Answer: B

• Question 58:

  This question will ask you to provide missing option.

  

  Which option is required to complete the program correctly?

  A. CAMPLIB

  B. FMTSEARCH

  C. LIBREF

  D. UTILLOC

  Correct Answer: C

• Question 59:

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

  Given the SAS date sets CLASS1 and CLASS2 CLASS1 CLASS2 NAME COURSE NAME COURSE Lauren MATH1 Smith MATH2 Patel MATH1 Farmer MATH2 Chang MATH1 Patel MATH2 Chang MATH3 Hiller MATH2 The following SAS program is submitted: Proc sql; Select name from CLASS1 select name from CLASS; quit; The following output is desired NAME Chang Chang Lauren

  Which SQL set operator completes the program and generates the desired output?

  A. UNION ALL

  B. EXCEPT ALL

  C. INTERSECT ALL

  D. OUTER UNION ALL

  Correct Answer: B