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

Answer: B

Latest A00-212 Dumps Valid Version with 184 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments