https://communities.sas.com/t5/ODS-and-Base-Reporting/proc-report-use-of-summary-data/m-p/5721#M2305 Hi:<BR /> I do not believe that what you want to do is possible. Your best bet for help is to contact Tech Support for possible other approaches (like a DATA _NULL_ report, or making 2 passes through the data. <BR /> <BR /> If PROC REPORT is doing the BREAK on the summary, you cannot suppress the break conditionally. If you are writing out a custom break line, you cannot execute the LINE statment conditionally -- you can only set a text string whose value is set conditionally:<BR /> [pre]<BR /> compute after brkvar;<BR /> if sales.sum = 0 then text_str = ' ';<BR /> else text_str = 'Sales: '||put(sales.sum,dollar14.);<BR /> line text_str $char50.;<BR /> endcomp;<BR /> [/pre]<BR /> in which case SOMETHING is still being written at the break -- but not being completely suppressed.<BR /> <BR /> cynthia Tue, 27 Nov 2007 20:36:11 GMT Cynthia_sas 2007-11-27T20:36:11Z https://communities.sas.com/t5/ODS-and-Base-Reporting/proc-report-use-of-summary-data/m-p/5720#M2304 I am working with proc report to summarize a large amount of data. When the summary line summarizes to zero I would like to omit that line (still using proc report). Is this possible?<BR /> <BR /> I have tried ommitting where line equals zero but this does not include all data in the final output. Tue, 27 Nov 2007 19:39:40 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/proc-report-use-of-summary-data/m-p/5720#M2304 deleted_user 2007-11-27T19:39:40Z https://communities.sas.com/t5/ODS-and-Base-Reporting/proc-report-use-of-summary-data/m-p/5721#M2305 Hi:<BR /> I do not believe that what you want to do is possible. Your best bet for help is to contact Tech Support for possible other approaches (like a DATA _NULL_ report, or making 2 passes through the data. <BR /> <BR /> If PROC REPORT is doing the BREAK on the summary, you cannot suppress the break conditionally. If you are writing out a custom break line, you cannot execute the LINE statment conditionally -- you can only set a text string whose value is set conditionally:<BR /> [pre]<BR /> compute after brkvar;<BR /> if sales.sum = 0 then text_str = ' ';<BR /> else text_str = 'Sales: '||put(sales.sum,dollar14.);<BR /> line text_str $char50.;<BR /> endcomp;<BR /> [/pre]<BR /> in which case SOMETHING is still being written at the break -- but not being completely suppressed.<BR /> <BR /> cynthia Tue, 27 Nov 2007 20:36:11 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/proc-report-use-of-summary-data/m-p/5721#M2305 Cynthia_sas 2007-11-27T20:36:11Z