SAS_Institute
A00-202 · Question #55
Given the following SAS data set ONE: ONE LEVEL AGE ------------ ---------- 1 10 2 20 3 20 2 10 1 10 2 30 SAS A00-202 Exam 3 10 2 20 3 30 1 10 The following SAS program is submitted: proc sql…
The correct answer is C. LEVEL MAX. See the full explanation below for the reasoning.
Question
Given the following SAS data set ONE:
ONE LEVEL AGE ------------ ---------- 1 10 2 20 3 20 2 10 1 10 2 30 SAS A00-202 Exam 3 10 2 20 3 30 1 10 The following SAS program is submitted:
proc sql; select level, max(age) as MAX from one group by level having max(age) > (select avg(age) from one); quit; Which one of the following reports is generated?
Options
- ALEVEL AGE
- BLEVEL AGE
- CLEVEL MAX
- DLEVEL MAX
How the community answered
(14 responses)- A7% (1)
- B7% (1)
- C71% (10)
- D14% (2)
Community Discussion
No community discussion yet for this question.