A00-202 Latest Exam Braindumps
Question 1: 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?
A. CATEGORY EARNINGS M 220 M 110 M 310 F 150 F 210
B. CATEGORY EARNINGS
M 640 F 360
C. CATEGORY EARNINGS
F 150 F 210
D. CATEGORY EARNINGS
F 360
Correct Answer: D
