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:; procsql; select rep, area, count(*) as TOTAL from one groupby rep, area; quit;