A00-212 · Question #34
Given the SAS data sets ONE and TWO: ONE TWO YEAR QTR BUDGET YEAR QTR SALES ------- ------- ----------- ------- ----- -------- 2001 3 500 2001 4 300 2001 4 400 2002 1 600 2003 1 350 The following…
Sign in or unlock A00-212 to reveal the answer and full explanation for question #34. The question stem and answer options stay visible for context.
Question
Given the SAS data sets ONE and TWO:
ONE TWO YEAR QTR BUDGET YEAR QTR SALES ------- ------- ----------- ------- ----- -------- 2001 3 500 2001 4 300 2001 4 400 2002 1 600 2003 1 350 The following SAS program is submitted:
proc sql; select two.*, budget from one <insert JOIN operator here> two on one.year = two.year; quit; The following output is desired:
YEAR QTR BUDGET SALES ------- ----- ----------- --------- 2001 4 300 500 2001 4 300 400 2002 1 600 Which JOIN operator completes the program and generates the desired output?
Options
- ALEFT JOIN
- BRIGHT JOIN
- CFULL JOIN
- DINNER JOIN
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.