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)- A3% (1)
- B77% (27)
- C11% (4)
- D9% (3)
Community Discussion
No community discussion yet for this question.