nerdexam
SAS_Institute

A00-212 · Question #31

Given the SAS date sets CLASS1 and CLASS2: CLASS1 CLASS2 NAME COURSE NAME COURSE ------- ----------- ------- ------------ Lauren MATH1 Smith MATH2 Patel MATH1 Farmer MATH2 Chang MATH1 Patel MATH2…

The correct answer is B. EXCEPT ALL. See the full explanation below for the reasoning.

Question

Given the SAS date sets CLASS1 and CLASS2:

CLASS1 CLASS2 NAME COURSE NAME COURSE ------- ----------- ------- ------------ Lauren MATH1 Smith MATH2 Patel MATH1 Farmer MATH2 Chang MATH1 Patel MATH2 Chang MATH3 Hillier MATH2 The following SAS program is submitted:

proc sql; select name from CLASS1 <insert SQL set operator here> select name from CLASS2; quit; The following output is desired:

NAME --------- Chang Chang Lauren Which SQL set operator completes the program and generates the desired output?

Options

  • AUNION ALL
  • BEXCEPT ALL
  • CINTERSECT ALL
  • DOUTER UNION ALL

How the community answered

(35 responses)
  • A
    3% (1)
  • B
    77% (27)
  • C
    11% (4)
  • D
    9% (3)

Community Discussion

No community discussion yet for this question.

Full A00-212 Practice