Q12
Single choice
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?