What I can do is this. Maybe @Cynthia_sas could give you a complete solution.
ods excel file = "c:\temp\temp.xlsx"
options(sheet_interval='none' embedded_titles='yes') ;
title;
ods escapechar = '^' ;
options missing = 0 orientation=landscape center ;
proc report data =sashelp.class nowd split = '-'
style(header)={tagattr="wrap:no" background=white
bordertopwidth=1 bordercolor=black
borderrightwidth=1 borderrightcolor=black
color=black just=c textalign=c}
style(report)={borderwidth=1 bordercolor=black just=c}
style(column)= {borderwidth=1 bordercolor=black just=r color=black tagattr='format:###,###,###,###,###0'}
style(summary)= [just=c textalign=c];
;
column ('^{style[borderbottomwidth=1 borderbottomcolor=white] Total}'
('^{style[borderbottomwidth=1 borderbottomcolor=white bordertopwidth=1 bordertopcolor=white] Category (before change/extension)'
('^{style[bordertopwidth=1 bordertopcolor=white] Performingtime'
sex weight height )))
(' Total'
('^{style[borderbottomwidth=1 borderbottomcolor=white color=white] _'
('^{style[bordertopwidth=1 bordertopcolor=white] Performingtime' weight=weight2 height=height2))
('^{style[borderbottomwidth=1 borderbottomcolor=white color=white] _'
('^{style[bordertopwidth=1 bordertopcolor=white] Performingtime2' weight=weight3 height=height3))
('^{style[borderbottomwidth=1 borderbottomcolor=white color=white] _'
('^{style[bordertopwidth=1 bordertopcolor=white] Performingtime3' weight=weight4 height=height4))
)
;
define sex / group;
define weight: / analysis sum ;
define height: / analysis sum ;
run ;
ods excel close;
... View more
