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?
mhminkov
3 years, 3 months ago