ODS - DOL and DUL

[DLROW]

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

[ballardw]

What is your ODS destination?

Note that the documentation for DOL and DUL says:

This option affects only the LISTING output. It has no affect on other ODS output.