请教，sas列表

感激bobguy ，也感谢楼上，理解万岁啊！

昨天用excel的数据透视表凑合着算了一夜，今天试试高手指点的proc tabulate

excel的数据透视表和tabulate等价的呀......

这不是为了学习sas吗，在应用中学习，加油加油

楼主的学习精神值得学习 膜拜ing

the follow code is easy to understand. you can run in your sas system to test.

data schdist;
input  school $ grade name $ gender $ ;
cards;
aaa 1 d1 f
aaa 1 i1 f
aaa 1 e1 m
aaa 2 d2 f
aaa 2 e2 m
bbb 1 g1 f
bbb 1 h1 m
bbb 2 g2 f
bbb 2 h2 m
bbb 2 k2 m
;
run;

proc tabulate data=schdist out=sch_2;
class school grade gender;
table school*(grade all) ,  (gender all=Total) *( n='N' pctn='%');
run;

For beginner, the follow is easy understand. Nice day.

data schdist;
input  school $ grade name $ gender $ ;
cards;
aaa 1 d1 f
aaa 1 i1 f
aaa 1 e1 m
aaa 2 d2 f
aaa 2 e2 m
bbb 1 g1 f
bbb 1 h1 m
bbb 2 g2 f
bbb 2 h2 m
bbb 2 k2 m
;
run;

proc tabulate data=schdist out=out_sch;
class school grade gender;
table school*(grade all) all=Totall,  (gender all=Total_1) *( n='N' pctn='%');
run;

受教了，谢谢楼上

学习下，各位辛苦了

9# bobguy

请问能解释下这一步吗？
proc tabulate data=tmp;
class     school     grade  gender;
table    (school *    grade)  all ,  (gender=' ' all) *( n='N' pctn='%');
run