input Sector $ Manager $ Department $ Sales @@;
datalines;
se 1 np1 50 se 1 p1 100 se 1 np2 120 se 1 p2 80
se 2 np1 40 se 2 p1 300 se 2 np2 220 se 2 p2 70
nw 3 np1 60 nw 3 p1 600 nw 3 np2 420 nw 3 p2 30
nw 4 np1 45 nw 4 p1 250 nw 4 np2 230 nw 4 p2 73
nw 9 np1 45 nw 9 p1 205 nw 9 np2 420 nw 9 p2 76
sw 5 np1 53 sw 5 p1 130 sw 5 np2 120 sw 5 p2 50
sw 6 np1 40 sw 6 p1 350 sw 6 np2 225 sw 6 p2 80
ne 7 np1 90 ne 7 p1 190 ne 7 np2 420 ne 7 p2 86
ne 8 np1 200 ne 8 p1 300 ne 8 np2 420 ne 8 p2 125
;
proc format;
value $sctrfmt 'se' = 'Southeast'
'ne' = 'Northeast'
'nw' = 'Northwest'
'sw' = 'Southwest';
value $mgrfmt '1' = 'Smith' '2' = 'Jones'
'3' = 'Reveiz' '4' = 'Brown'
'5' = 'Taylor' '6' = 'Adams'
'7' = 'Alomar' '8' = 'Andrews'
'9' = 'Pelfrey';
value $deptfmt 'np1' = 'Paper'
'np2' = 'Canned'
'p1' = 'Meat/Dairy'
'p2' = 'Produce';
run;
proc report data=grocery headline headskip nowd ;
column sector manager department,sales sales;
define sector /order format =$sctrfmt.;
define manager/group format =$mgrfmt.;
define department /across format =$deptfmt.;
define sales /analysis format= dollar11.2;
run;
谁能帮我看一下这个code,为什么在最后输出的report里,salary的summary没有和之前的individual值一一对应?
output 结果:
The SASSystem 18:17 Saturday, May 16,2009 10
Department
Meat
Canned Dairy Paper Produce
Sector Manager Sales Sales Sales Sales Sales
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
Northeast Alomar $420.00 . . . $90.00
. $190.00 . . $190.00
. . $90.00 . $420.00
. . . $86.00 $86.00
Andrews $420.00 . . . $200.00
. $300.00 . . $300.00
. . $200.00 . $420.00
. . . $125.00 $125.00
Northwest Brown $230.00 . . . $45.00
. $250.00 . . $250.00
. . $45.00 . $230.00
. . . $73.00 $73.00
Pelfrey $420.00 . . . $45.00
. $205.00 . . $205.00
. . $45.00 . $420.00
. . . $76.00 $76.00
Reveiz $420.00 . . . $60.00
. $600.00 . . $600.00
. . $60.00 . $420.00
. . . $30.00 $30.00
Southeast Jones $220.00 . . . $40.00
. $300.00 . . $300.00
. . $40.00 . $220.00
. . . $70.00 $70.00
Smith $120.00 . . . $50.00
. $100.00 . . $100.00
. . $50.00 . $120.00
. . . $80.00 $80.00
Southwest Adams $225.00 . . . $40.00
. $350.00 . . $350.00
. . $40.00 . $225.00
. . . $80.00 $80.00
Taylor $120.00 . . . $53.00
. $130.00 . . $130.00
. . $53.00 . $120.00
. . . $50.00 $50.00