SAS_Institute
A00-212 · Question #75
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…
The correct answer is D. REP AVERAGE. See the full explanation below for the reasoning.
Question
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?
Options
- AREP AVERAGE
- BREP AVERAGE
- CREP AVERAGE
- DREP AVERAGE
How the community answered
(46 responses)- A4% (2)
- B7% (3)
- C13% (6)
- D76% (35)
Community Discussion
No community discussion yet for this question.