nerdexam
SAS_Institute

A00-202 · Question #39

Given the following SAS data set ONE: ONE REP COST -------------- ---------- SMITH 200 SMITH 400 JONES 100 SMITH 600 JONES 100 JONES 200 JONES 400 SMITH 800 JONES 100 JONES 300 SAS A00-202 Exam The…

The correct answer is A. REP AVERAGE. See the full explanation below for the reasoning.

Question

Given the following SAS data set ONE:

ONE REP COST -------------- ---------- SMITH 200 SMITH 400 JONES 100 SMITH 600 JONES 100 JONES 200 JONES 400 SMITH 800 JONES 100 JONES 300 SAS A00-202 Exam The following SAS program is submitted:

proc sql; select rep, avg(cost) as AVERAGE from one group by rep having avg(cost) > (select avg(cost) from one); quit; Which one of the following reports is generated?

Options

  • AREP AVERAGE
  • BREP AVERAGE
  • CREP AVERAGE
  • DREP AVERAGE

How the community answered

(42 responses)
  • A
    69% (29)
  • B
    17% (7)
  • C
    10% (4)
  • D
    5% (2)

Community Discussion

No community discussion yet for this question.

Full A00-202 Practice