nerdexam
SAS_Institute

A00-202 · Question #62

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…

The correct answer is D. 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

(35 responses)
  • A
    3% (1)
  • B
    3% (1)
  • C
    11% (4)
  • D
    83% (29)

Community Discussion

No community discussion yet for this question.

Full A00-202 Practice