SAS_Institute
A00-212 · Question #75
A00-212 Question #75: Real Exam Question with Answer & Explanation
Sign in or unlock A00-212 to reveal the answer and full explanation for question #75. The question stem and answer options stay visible for context.
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
Unlock A00-212 to see the answer
You've previewed enough free A00-212 questions. Unlock A00-212 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.