nerdexam
SAS_Institute

A00-202 · Question #4

Given the following SAS data sets ONE and TWO: ONE TWO NUM CHAR1 NUM CHAR2 ----------- ------- ----------- ------------- 1 A1 2 X1 1 A2 2 X2 2 B1 3 Y 2 B2 5 V 4 D The following SAS program is…

The correct answer is B. data three;D.data three. 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 A1 2 X1 1 A2 2 X2 2 B1 3 Y 2 B2 5 V 4 D The following SAS program is submitted creating the output table THREE:

proc sql; create table three as select one.num, char1, char2 from one, two where one.num = two.num; quit; THREE NUM CHAR1 CHAR2 ------------- --------------- --------- 2 B1 X1 2 B1 X2 2 B2 X1 2 B2 X2 Which one of the following DATA step programs creates an equivalent SAS data set THREE?

Options

  • Adata three;C.data three;
  • Bdata three;D.data three;
  • Cdata three;
  • Ddata three;

How the community answered

(33 responses)
  • A
    9% (3)
  • B
    82% (27)
  • C
    3% (1)
  • D
    6% (2)

Community Discussion

No community discussion yet for this question.

Full A00-202 Practice