SAS Certified Adv Programmer 130 Questions (24)
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?
A.
COUNTRY CITY TOTAL UK MARLOW 10 UK LONDON 20 USA BOSTON 50 USA DALLAS 20
B.
COUNTRY CITY TOTAL UK LONDON 20 UK MARLOW 10 USA BOSTON 50 USA DALLAS 20
C.
COUNTRY CITY TOTAL USA BOSTON 50
D.
COUNTRY CITY TOTAL UK MARLOW 10 UK LONDON 20 USA DALLAS 20 USA BOSTON 50
Topics:
SAS Adv Questions |
3 Comments »
B
USA Boston should be 30 instead of 50.
Hello, this doesn’t seem possible at all. The correct answer should have 30 as a total for country USA/ city Boston. Never 50.