ODS - DOL and DUL

DLROW — Tue, 05 Mar 2019 18:21:37 GMT

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

Re: ODS - DOL and DUL

ballardw — Tue, 05 Mar 2019 21:41:38 GMT

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.

topic Re: ODS - DOL and DUL in New SAS User

ODS - DOL and DUL

Re: ODS - DOL and DUL