Hi, dol and dul is not working. Please see the code below and let me know what I am missing. Thanks.
ods excel
file = &outfile.
PROC REPORT Data=Account nowd
style(report)=[borderstyle=solid bordercolor=Lavender verticalalign=T cellspacing=0 cellpadding=0]
style(header)=[background=STB color=white fontfamily=calibri FONT_WEIGHT=BOLD fontsize=3.3 textalign= L verticalalign=T cellheight=.1in tagattr='Wrap:no' borderstyle=solid bordercolor=black]
style(column)=[fontfamily=calibri fontsize=2.8 textalign=Left verticalalign=c borderstyle=solid bordercolor=Lavender cellheight=.1in tagattr='Wrap:no'];
COLUMNS Name ID AMT_A AMT_B AMT_C ID_2 ID_3
TOTAL_AMT ;
define Name/ group 'Name' style(column)=[background=Lavender color=black textalign=left frame=void rules=none];
define ID /group 'ID ' style(column)=[background=Lavender color=black textalign=left frame=void rules=none];
define AMT_A / group 'AMT_A' style(column)=[background=Lavender color=black textalign=left frame=void rules=none] f=dollar18.;
define AMT_B / group 'AMT_B' style(column)=[background=Lavender color=black textalign=left] f=dollar18.;
define AMT_C/ group 'AMT_C' style(column)=[background=Lavender color=black textalign=left];
define ID_2 / group 'ID_2' style(column)=[background=Lavender color=black textalign=left];
define ID_3 / display 'ID_3 ' style(column)=[background=Lavender color=black textalign=left];
define TOTAL_AMT / 'TOTAL_AMT' style(column)=[background=Lavender color=black textalign=left] f=dollar18.;
break after Name / skip summarize dol dul suppress style=[font_weight=bold] ;
compute after Name;
line '';
endcomp;
RUN;
QUIT;
| | | | | | | | |
| Name | ID | AMT_A | AMT_B | AMT_C | ID_2 | ID_3 | Total_Amt |
| AAAAAAA | 5643 | $30,000 | $0 | $35 | 67895 | 234567 | $167,004 |
| | | | | | | 456789 | $41,209 |
| | | | | | | | $208,213 |
