SAS_Institute
A00-212 · Question #31
A00-212 Question #31: Real Exam Question with Answer & Explanation
Sign in or unlock A00-212 to reveal the answer and full explanation for question #31. The question stem and answer options stay visible for context.
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
Unlock A00-212 to see the answer
You've previewed enough free A00-212 questions. Unlock A00-212 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.