By admin | October 2, 2009

SAS Certified Base Programmer 123 Questions (99)

Exhibit: view two reports. Assume permanent variable labels have been assigned.

Output we are getting
Regin Asia Subsidiary Total Sales
Bangkok $1,996
Bangkok $3,033
Bangkok $3,230
Bangkok $3,019
Bangkok $5,389
Seoul $60,712
Seoul $11,754
Seoul $116,333
Seoul $4,978
Seoul $149,013
Seoul $937
Seoul $20,448
Seoul $78,234
Tokyo $1,155

——————————————————————————————————————————————-

Output we want!
Regin Asia Subsidiary Total Sales
Bangkok $16,667
Seoul $442,409
Tokyo $1,155

The following SAS program is submitted and produces the first report:

proc report data = sasuser.shoes nowd;
    column region subsidiary sales;
    define subsidiary / display;
    define region / group;
    define sales / sum;
run;

Which one of the following corrects the program above to produce the second report shown in the exhibit?

A. Define the variable SUBSIDIARY with a SUM usage.
B. Define the variable SUBSIDIARY with a GROUP usage.
C. Define the variable SUBSIDIARY with an ORDER usage.
D. Define the variable SUBSIDIARY with an ACROSS usage.

One comment | Add One

  1. admin - 10/2/2009 at 2:33 pm

    B

Leave a Comment

Leave a Reply

Your email address will not be published. Required fields are marked *