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.
Topics:
SAS Base Questions |
1 Comment »
B