nerdexam
SAS_Institute

A00-202 · Question #51

SAS A00-202 Exam Given the following SAS data sets ONE and TWO: ONE TWO YEAR QTR BUDGET YEAR QTR SALES ----------- ----------- ----------- ---------- ----------- --------- 2001 3 500 2001 4 300 2001…

The correct answer is B. YEAR QTR BUDGET SALES. See the full explanation below for the reasoning.

Question

SAS A00-202 Exam Given the following 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 2002 1 700 The following SAS program is submitted:

proc sql; select one.*, sales from one left join two on one.year = two.year; quit; Which one of the following reports is generated?

Options

  • AYEAR QTR BUDGET SALES
  • BYEAR QTR BUDGET SALES
  • CYEAR QTR BUDGET SALES
  • DYEAR QTR BUDGET SALES

How the community answered

(43 responses)
  • A
    5% (2)
  • B
    81% (35)
  • C
    12% (5)
  • D
    2% (1)

Community Discussion

No community discussion yet for this question.

Full A00-202 Practice