nerdexam
SAS_Institute

A00-202 · Question #38

A00-202 Question #38: Real Exam Question with Answer & Explanation

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

Question

Given the following SAS data set ONE: ONE COUNTRY CITY VISIT ----------------- ---------------- -------- USA BOSTON 10 UK LONDON 5 USA DALLAS 10 UK MARLOW 10 USA BOSTON 20 UK LONDON 15 USA DALLAS 10 The following SAS program is submitted: proc sql; select country, city, sum(visit) as TOTAL from one group by country, city SAS A00-202 Exam order by country, total desc; quit; Which one of the following reports is generated?

Options

  • ACOUNTRY CITY TOTAL
  • BCOUNTRY CITY TOTAL
  • CCOUNTRY CITY TOTAL
  • DCOUNTRY CITY TOTAL

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