Hi, I need someone to help me with the following.... Today I am using the following Syntax: ods xml tagset=ExcelXP130 options(absolute_column_width = '15,15,15,15,15,15' sheet_interval='None'); PROC REPORT DATA=if_unite_out_final headline headskip norkeys missing nowindows; COLUMN ("Final Report" category AMOUNT_ZERO_2 AMLA_ALL_2 AMLA_ALL_HASHKAL_2 ratio_aml_2) ; DEFINE MON / order 'Date' format = mmyys7. ; DEFINE category / display ' Category' format = cat_card.; DEFINE AMOUNT_ZERO_2 / analysis 'Total Sum' format = COMMA20.2 style(column)={tagattr="format:###,##0.00" just=l}; DEFINE AMLA_ALL_2 / analysis 'Part' format = COMMA20.2 style(column)={tagattr="format:###,##0.00" just=l}; DEFINE AMLA_ALL_HASHKAL_2 / analysis 'Total include all' format = COMMA20.2 style(column)={tagattr="format:###,##0.00" just=l}; BREAK AFTER mon / SUMMARIZE UL OL style=[font_weight=bold]; compute after; ORG = 999; endcomp; RUN; I need the same output with the only difference that the field "MON" will be shown in each line. When I change "order" to "display" it does not give me the ability to summerize in the "MON" (month) level. Anyone knows what can I do? Thanks!
... View more
