nerdexam
SAS_Institute

A00-202 · Question #62

A00-202 Question #62: Real Exam Question with Answer & Explanation

Sign in or unlock A00-202 to reveal the answer and full explanation for question #62. The question stem and answer options stay visible for context.

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

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.

Full A00-202 Practice