Which one of the following reports is generated?

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

View Answer

Answer: B