两个方案,第一个简单点,但soc pt level 三个变量不在一列;第二个方案多几个步骤,不知道别人能不能提供更简洁的步骤。
方案一:
proc report data=ae missing;
column soc pt level n;
define soc/group;
define pt/group;
define level/group;
define n/analysis sum '例次';
break before pt/summarize style=[backgroundcolor=#DBEEF4 color=blue];
break before soc/summarize style=[backgroundcolor=#FFF2CC color=red fontweight=bold];
title 'xxxx';
run;
方案二:
proc report data=ae missing;
column soc pt level n;
define soc/group;
define pt/group;
define level/group;
define n/analysis sum '例次';
break before pt/summarize;
break before soc/summarize;
ods output report=work.aaa;
title 'xxxx';
run;
data work.aaa;
retain var n;
set aaa;
array varlist[*] $ soc pt level;
do i=1 to dim(varlist) by 1;
if missing(varlist[i])=0 then var=varlist[i];
end;
keep var n;
run;
proc print data=work.aaa;run;