SAS Training

SAS Certified Adv Programmer 130 Questions (4)

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

One comment | Add One

Leave a Comment