Which one of the following reports is generated?

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

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?
A . REP AVERAGE JONES 200
B . REP AVERAGE JONES 320
C . REP AVERAGE SMITH 320
D . REP AVERAGE SMITH 500

View Answer

Answer: D