Help using Base SAS procedures

PROC REPORT suppress a particular row of output?

Reply
N/A
Posts: 0

PROC REPORT suppress a particular row of output?

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
Occasional Contributor
Posts: 10

Re: PROC REPORT suppress a particular row of output?

Posted in reply to deleted_user
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.
N/A
Posts: 0

Re: PROC REPORT suppress a particular row of output?

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.
Super Contributor
Posts: 394

Re: PROC REPORT suppress a particular row of output?

Posted in reply to deleted_user
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.
Ask a Question
Discussion stats
  • 3 replies
  • 172 views
  • 0 likes
  • 3 in conversation