nerdexam
SAS_Institute

A00-202 · Question #58

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…

The correct answer is C. 3. 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 SQL program is submitted:

proc sql; create table two as select distinct age from one where age < 33; quit; How many rows are written to the SAS data set TWO?

Options

  • A5
  • B6
  • C3
  • D4

How the community answered

(25 responses)
  • A
    4% (1)
  • B
    4% (1)
  • C
    80% (20)
  • D
    12% (3)

Community Discussion

No community discussion yet for this question.

Full A00-202 Practice