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:; procsql;
select rep, avg(cost) as AVERAGE from one groupby rep having avg(cost) > (select avg(cost) from one); quit;