nerdexam
SAS_Institute

A00-212 · Question #96

Given the following SAS data sets ONE and TWO: ONE TWO NUM CHAR1 NUM CHAR2 1 A 2 X 2 B 3 Y 4 D 5 V The following SAS program is submitted creating the output table THREE: data three; set one two…

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

Question

Given the following SAS data sets ONE and TWO:

ONE TWO NUM CHAR1 NUM CHAR2 1 A 2 X 2 B 3 Y 4 D 5 V The following SAS program is submitted creating the output table THREE:

data three; set one two; run; THREE NUM CHAR1 CHAR2 1 A 2 B 4 D 2 X 3 Y 5 V Which one of the following SQL programs creates an equivalent SAS data set THREE?

Options

  • Aproc sql;
  • Bproc sql;
  • Cproc sql;
  • Dproc sql;

How the community answered

(35 responses)
  • A
    80% (28)
  • B
    11% (4)
  • C
    3% (1)
  • D
    6% (2)

Community Discussion

No community discussion yet for this question.

Full A00-212 Practice