SAS_Institute
A00-202 · Question #39
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 SAS A00-202 Exam The…
The correct answer is A. 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 SAS A00-202 Exam 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
(42 responses)- A69% (29)
- B17% (7)
- C10% (4)
- D5% (2)
Community Discussion
No community discussion yet for this question.