topic Re: PROC REPORT in SAS Programming

PROC REPORT

adig — Tue, 26 Mar 2019 15:30:31 GMT

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!

Re: PROC REPORT

ballardw — Tue, 26 Mar 2019 16:04:34 GMT

Try making another variable with the values of MON. Place it first in the Columns statement.

In the define make the new variable the ORDER variable with the option NOPRINT.

Make MON a display variable and change the Break After to use the new variable.

Here is a short example using data from the SASHELP.CLASS data set. I am using SEX in the role of your MON variable.

data work.class;
   set sashelp.class;
   og = sex;
run;


proc report data=work.class;
   columns og sex age height;
   define og /order noprint;
   define sex / display ;
   define age/ display;
   define height/analysis;
   break after og/summarize;
run;

Re: PROC REPORT

adig — Wed, 27 Mar 2019 13:04:40 GMT

Great! Thank you!

I also need that the line of the summary will also include the value of the MON (in your example - the value of the sex 'F'/'M').

How can I do this?

Thanks!

Re: PROC REPORT

adig — Thu, 28 Mar 2019 04:33:37 GMT

someone can help ?

Re: PROC REPORT

andreas_lds — Thu, 28 Mar 2019 09:43:50 GMT

Not sure, if i understood what you need. Do you need a list of all contributing class-values in the summary line?

Re: PROC REPORT

adig — Thu, 28 Mar 2019 11:42:10 GMT

Look at the example of sashelp.class.

the code "break after og/summarize;" gives me the summary of the sex.

Yet, in the output, in the line of the summary it is not written whether the summary is for 'F' of 'M'. only the sum is written.

I need that also the rellevant sex('F'/'M') will also appear in the line of the summary...

Re: PROC REPORT

adig — Sun, 31 Mar 2019 05:20:01 GMT

no one..?

Re: PROC REPORT

andreas_lds — Sun, 31 Mar 2019 11:01:24 GMT

You could, by now, have read the documentation of proc report and find a solution. If you need sub-totals, you have to change "display" to "group" and use the rbreak statement. See the docs for an example.