SAS Certified Adv Programmer 130 Questions (28)
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?
A.
REP AREA COUNT JONES EAST 100 JONES NORTH 600 JONES WEST 500 SMITH NORTH 800 SMITH SOUTH 200
B.
REP AREA TOTAL JONES EAST 100 JONES NORTH 600 JONES WEST 500 SMITH NORTH 800 SMITH SOUTH 200
C.
REP AREA TOTAL JONES EAST 1 JONES NORTH 2 JONES WEST 3 SMITH NORTH 3
D.
REP AREA TOTAL JONES EAST 1 JONES NORTH 2 JONES WEST 3 SMITH NORTH 3 SMITH SOUTH 1
Topics:
SAS Adv Questions |
1 Comment »
D