SAS_Institute
A00-212 · Question #144
Given the following SAS data set ONE: ONE CATEGORY AGE SALARY BONUS M 28 200 20 M 25 100 10 M 28 300 10 M 33 300 30 F 18 100 50 F 25 200 10 F 35 400 50 The following SAS program is submitted: proc…
The correct answer is A. CATEGORY EARNINGS. See the full explanation below for the reasoning.
Question
Given the following SAS data set ONE:
ONE CATEGORY AGE SALARY BONUS M 28 200 20 M 25 100 10 M 28 300 10 M 33 300 30 F 18 100 50 F 25 200 10 F 35 400 50 The following SAS program is submitted:
proc sql; select distinct category, sum(sum(salary,bonus)) as EARNINGS from one where age < 30 group by category having calculated EARNINGS < 500; quit; Which one of the following reports will be generated?
Options
- ACATEGORY EARNINGS
- BCATEGORY EARNINGS
- CCATEGORY EARNINGS
- DCATEGORY EARNINGS
How the community answered
(24 responses)- A71% (17)
- B4% (1)
- C17% (4)
- D8% (2)
Community Discussion
No community discussion yet for this question.