nerdexam
SAS_Institute

A00-212 · Question #99

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…

The correct answer is C. REP AREA TOTAL D. REP AREA TOTAL. See the full explanation below for the reasoning.

Question

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?

Options

  • AREP AREA COUNT
  • BREP AREA TOTAL
  • CREP AREA TOTAL
  • DREP AREA TOTAL

How the community answered

(55 responses)
  • A
    5% (3)
  • B
    15% (8)
  • C
    80% (44)

Community Discussion

No community discussion yet for this question.

Full A00-212 Practice