topic Re: rbreak in proc report not getting resolve in SAS Procedures

rbreak in proc report not getting resolve

Subhan — Wed, 29 Oct 2014 12:22:26 GMT

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;

Re: rbreak in proc report not getting resolve

Ksharp — Wed, 29 Oct 2014 12:57:15 GMT

Show some sample data .

Re: rbreak in proc report not getting resolve

data_null__ — Wed, 29 Oct 2014 15:23:54 GMT

You don't have any "ANALYSIS" variables.

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

Re: rbreak in proc report not getting resolve

bharathtuppad — Thu, 30 Oct 2014 03:31:32 GMT

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;

Re: rbreak in proc report not getting resolve

Subhan — Thu, 30 Oct 2014 05:58:57 GMT

Thank You all for your help.It worked.