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…

Sign in or unlock A00-202 to reveal the answer and full explanation for question #51. The question stem and answer options stay visible for context.

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

Unlock A00-202 to see the answer

You've previewed enough free A00-202 questions. Unlock A00-202 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-202 Practice