测试数据:
DATA TEST;
INPUT X $ Y $ Z $ N;
CARDS;
A a aa 11
A a ab 12
A b ba 21
A b bb 22
B a aa 33
B a ab 34
B b ba 43
B b bb 44
;
希望得到的报表格式为:
求高手们帮忙看看呢,谢谢了...
DATA TEST;
INPUT X $ Y $ Z $ N;
CARDS;
A a aa 11
A a ab 12
A b ba 21
A b bb 22
B a aa 33
B a ab 34
B b ba 43
B b bb 44
;
run;
options linesize=256;
proc report data=test nowd SPANROWS NOCOMPLETECOLS
style(report)=[cellspacing=2 borderwidth=2 bordercolor=blue font_face="gb_2312"]
style(header)=[foreground=cx3A5FCD font_face="gb_2312"]
style(column)=[foreground=black font_face="times new roman" font_size=2 ]
style(lines)=[foreground=black background=black font_style=italic font_weight=bold font_size=2 font_face="gb_2312"]
style(summary)=[ background=cxaeadd9 font_face="times new roman" font_size=2 just=r] ;
column x y,z,n;
define x /group '' order=data;
define y /across '' center order=data;
define z /across '' center order=data;
define n / '' group center '';
quit;