Help using Base SAS procedures

rbreak in proc report not getting resolve

Accepted Solution Solved
Reply
New Contributor
Posts: 3
Accepted Solution

rbreak in proc report not getting resolve

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;


Accepted Solutions
Solution
‎10-29-2014 11:23 AM
Respected Advisor
Posts: 3,799

Re: rbreak in proc report not getting resolve

You don't have any "ANALYSIS" variables.

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

10-29-2014 10-22-50 AM.png

View solution in original post


All Replies
Super User
Posts: 10,044

Re: rbreak in proc report not getting resolve

Show some sample data .

Solution
‎10-29-2014 11:23 AM
Respected Advisor
Posts: 3,799

Re: rbreak in proc report not getting resolve

You don't have any "ANALYSIS" variables.

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

10-29-2014 10-22-50 AM.png
Contributor
Posts: 27

Re: rbreak in proc report not getting resolve

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;

New Contributor
Posts: 3

Re: rbreak in proc report not getting resolve

Thank You all for your help.It worked.

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 222 views
  • 3 likes
  • 4 in conversation