topic Re: PROC REPORT suppress a particular row of output? in SAS Procedures

PROC REPORT suppress a particular row of output?

deleted_user — Wed, 31 Mar 2010 20:44:06 GMT

I have a proc report with a number of compute blocks, breaks, and rbreak, styles, etc., but I need to suppress one particular line of the output, a line that comes from the dataset detail, not a break or rbreak. I would ideally like to just put something in a compute block like "if var1 eq 'x' then delete", but that obviously doesn't work.

So, is there a way to do this within PROC REPORT? I'm sending output to RTF.

Thanks for any suggestions.

David

Re: PROC REPORT suppress a particular row of output?

Ross — Wed, 31 Mar 2010 21:47:15 GMT

Why not just eliminate it by subsetting the data by using a where statement for the Proc Report "where var1^='x';". This is no good if it necessary for any of the compute blocks otherwise it should work.

Re: PROC REPORT suppress a particular row of output?

deleted_user — Fri, 02 Apr 2010 15:49:11 GMT

Thanks, but exactly... I need the observations to compute summary lines. So I want to show all the subtotals but not the detail for every category for which there's a subtotal.

Re: PROC REPORT suppress a particular row of output?

Tim_SAS — Fri, 02 Apr 2010 16:14:40 GMT

No, there's no way for PROC REPORT to delete or skip a row in a report. You'll have to fix up your data before calling PROC REPORT.