SAS_Institute
A00-212 · Question #120
Given the following SAS data set ONE: ONE LEVEL AGE 1 10 2 20 3 20 2 10 1 10 2 30 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…
The correct answer is D. 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 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
(33 responses)- A6% (2)
- B3% (1)
- C12% (4)
- D79% (26)
Community Discussion
No community discussion yet for this question.