SAS_Institute
A00-202 · Question #38
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 correct answer is D. COUNTRY CITY TOTAL. See the full explanation below for the reasoning.
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
How the community answered
(31 responses)- A6% (2)
- B3% (1)
- C16% (5)
- D74% (23)
Community Discussion
No community discussion yet for this question.