SAS_Institute
A00-202 · Question #39
A00-202 Question #39: Real Exam Question with Answer & Explanation
Sign in or unlock A00-202 to reveal the answer and full explanation for question #39. 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 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
Unlock A00-202 to see the answer
You've previewed enough free A00-202 questions. Unlock A00-202 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.