data C1;
input SF@@ ;/* SF为省份代号*/
datalines;
1 1 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 2 2 3 3 3 3 3 3 3 3 3
;
run;
data C2;
input FD@@;/*FD为分店代号*/
datalines;
1 1 1 2 2 2 3 3 3 1 1 1 2 2 2 3 3 3 1 1 1 2 2 2 3 3 3
;
run;
data C3;
input MZ@@;/*MZ为书名代号*/
datalines;
1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3
;
run;
data C4;
input SL@@;/*书本数量*/
datalines;
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
;
run;
data C5;
merge C1 C2 C3 C4;
;
run;
proc tabulate data=C5;
class SF FD MZ;
var SL;
label SF=省份 FD=分店号 MZ=书名代号 SL=数量;
keylabel SUM=总和;
table SF,FD*SUM,MZ*SL;
run;

运行之后,发现每个省份的1号分店的1类书的数量不对,求解