nerdexam
SAS_Institute

A00-212 · Question #143

Given the following SAS data set ONE: ONE JOB LEVEL SALARY ACC 2 300 SEC 1 100 SEC 2 200 MGR 3 700 ACC 1 . ACC 3 . MGR 2 400 The following SAS data set TWO is created: TWO JOB LEVEL BONUS ACC 2 30…

The correct answer is D. proc sql;D.proc sql. See the full explanation below for the reasoning.

Question

Given the following SAS data set ONE:

ONE JOB LEVEL SALARY ACC 2 300 SEC 1 100 SEC 2 200 MGR 3 700 ACC 1 . ACC 3 . MGR 2 400 The following SAS data set TWO is created:

TWO JOB LEVEL BONUS ACC 2 30 MGR 3 70 MGR 2 40 Which one of the following SAS programs creates data set TWO?

Options

  • Aproc sql;
  • Bproc sql;
  • Cproc sql;
  • Dproc sql;D.proc sql;

How the community answered

(35 responses)
  • A
    3% (1)
  • B
    14% (5)
  • C
    6% (2)
  • D
    77% (27)

Community Discussion

No community discussion yet for this question.

Full A00-212 Practice