nerdexam
SAS_Institute

A00-212 · Question #103

Given the following SAS data set ONE: ONE CATEGORY AGE SALARY BONUS --------- ---- ----- ----- M 28 200 . M 25 100 10 F 18 100 50 F 25 200 10 The following SAS program is submitted: proc sql; create…

The correct answer is B. 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 . M 25 100 10 F 18 100 50 F 25 200 10 The following SAS program is submitted:

proc sql; create table two as select category, salary + bonus as EARNINGS from one; quit; Which one of the following represents the data values stored in the data set TWO?

Options

  • ACATEGORY EARNINGS
  • BCATEGORY EARNINGS
  • CCATEGORY SALARY BONUS EARNINGS
  • DCATEGORY SALARY BONUS EARNINGS

How the community answered

(33 responses)
  • A
    12% (4)
  • B
    79% (26)
  • C
    6% (2)
  • D
    3% (1)

Community Discussion

No community discussion yet for this question.

Full A00-212 Practice