nerdexam
SAS_Institute

A00-202 · Question #2

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…

The correct answer is D. 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;D.proc sql;
  • Bproc sql;C.proc sql;
  • Cproc sql;
  • Dproc sql;

How the community answered

(40 responses)
  • A
    13% (5)
  • B
    3% (1)
  • C
    5% (2)
  • D
    80% (32)

Community Discussion

No community discussion yet for this question.

Full A00-202 Practice