nerdexam
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.

Full A00-212 Practice