SAS_Institute
A00-212 · Question #95
A00-212 Question #95: Real Exam Question with Answer & Explanation
Sign in or unlock A00-212 to reveal the answer and full explanation for question #95. 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 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-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.