nerdexam
SAS_Institute

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…

The correct answer is B. RIGHT JOIN. See the full explanation below for the reasoning.

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

How the community answered

(49 responses)
  • A
    6% (3)
  • B
    76% (37)
  • C
    14% (7)
  • D
    4% (2)

Community Discussion

No community discussion yet for this question.

Full A00-212 Practice