Q1
Single choice
Given the following SAS data set ONE:
ONE
REP AREA COST
------------------------------------
SMITH NORTH 100
SMITH SOUTH 200
JONES EAST 100
SMITH NORTH 300
JONES WEST 100
JONES NORTH 200
JONES NORTH 400
SMITH NORTH 400
JONES WEST 100
JONES WEST 300
The following SAS program is submitted:
proc sql;
select rep, area, count(*) as TOTAL
from one group by rep, area;
quit;
Which one of the following reports is generated?