Which one of the following reports is generated?

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
JONES WEST 3
SMITH NORTH 3
SMITH SOUTH 1

D . REP AREA TOTAL
JONES EAST 1
JONES NORTH 2
JONES WEST 3
SMITH NORTH 3
SMITH SOUTH 1
SMITH NORTH 3
SMITH SOUTH 1

Answer: CD

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