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

Answer: D

Latest A00-212 Dumps Valid Version with 184 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments