rbreak in proc report not getting resolve

[Subhan]

Hi,

I am trying to resolve the below sas code for output the .rtf file.

But I am getting the blank value in  summarized row.

I think the code "rbreak after /  summarize ;" is not getting resolved.

Can you please help me to resolve the same.

ods rtf file = "....\....Report.rtf" startpage = no bodytitle;

ods escapechar = '^';

proc report nowindows data=x style(report)={outputwidth=6in}

    style(header)={background=blue};

column source Record_count Total_amount;

define source/display 'SOURCE' style(column)=[just=center];

define Record_count/display 'RECORD COUNT' style(column)=[just=center] ;

define Total_amount/display 'Total Amount' style(column)=[just=center] ;

rbreak after /  summarize ;

title "INPUT FILES";

footnote1;

footnote2;

run;

ods rtf close;

[Ksharp]

Show some sample data .

[data_null__ · Accepted solution]

You don't have any "ANALYSIS" variables.

proc report data=sashelp.class list nowd;
   columns _all_;
   define _numeric_ / analysis;
   rbreak after / summarize;
   run;

[bharathtuppad]

You have given the option display for record count and total_amount. Thats why you are not getting the totals. Apply analysis or remove the define statement for the varaible for which you want totals.

proc report nowindows data=sashelp.class style(report)={outputwidth=6in}

    style(header)={background=blue};

column source record_count total_amount;

define source/display 'SOURCE' style(column)=[just=center];

define record_count/analysis 'RECORD COUNT' style(column)=[just=center] ;

define total_amount/analysis 'Total Amount' style(column)=[just=center] ;

rbreak after /  summarize ;

title "INPUT FILES";

footnote1;

footnote2;

run;

[Subhan]

Thank You all for your help.It worked.