← Back to exam page

A00-212 – SAS Advanced Programming for SAS 9

Loading demo links...

Showing 1–3 of 6 questions

Question 1

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?

Select all that apply, then click Submit answer.

  • ○

    REP AREA COUNT
    JONES EAST 100
    JONES NORTH 600
    JONES WEST 500
    SMITH NORTH 800 SMITH SOUTH 200
     
  • ○

    REP AREA TOTAL
    JONES EAST 100
    JONES NORTH 600
    JONES WEST 500
    SMITH NORTH 800 SMITH SOUTH 200
     
  • ○

    REP AREA TOTAL
    JONES EAST 1
    JONES NORTH 2
    JONES WEST 3
    SMITH NORTH 3
    JONES WEST 3
    SMITH NORTH 3 SMITH SOUTH 1
     
  • ○

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

Question 2

Given the SAS data sets shown on the left, the SAS program on the right is submitted.

What will be the result when this program is executed?

Select an option, then click Submit answer.

  • ○

    Option A

  • ○

    Option B

  • ○

    Option C

  • ○

    Option D

Question 3

The following SAS program is submitted:

%let value = .5;

%let add = 5;

%let newval = %eval(&value + &add);

Which one of the following is the resulting value of the macro variable NEWVAL?

Select an option, then click Submit answer.

  • ○

    5

  • ○

    5.5

  • ○

    .5 + 5

  • ○

    null