PROC REPORT: How to hide cells from report

[MelissaM]

I'm trying to move from my comfortable PROC TABULATE towards PROC REPORT. It appears to have many more options for my purposes. Here is my current objective:

1) I want to keep the row sums, and hide (or maybe color white) the computed column.

2) In the listing window, the summary border shows around each cell. In ODS PDF and ODS RTF, it does not show at all. I just want one bold box to show in ODS PDF around the summary row.

Your help is always appreciated. (SAS Windows V9.4M4)

data have;

input A B C ;

DATALINES;

1 .4 1

2 1 0

3 2 1

4 1.2 0

;

ods pdf ;

PROC REPORT DATA=have nowd

style(summary)={ foreground=black borderwidth=2 bordercolor=black } ;

COLUMNS A B C ratio;

DEFINE A / display 'Subject';

DEFINE B / sum 'Time in Study';

DEFINE C / sum 'Number of Events';

define ratio / computed 'Event Rate' Format=5.3 ;

compute ratio ;

ratio=B.sum / C.sum ;

endcomp;

rbreak after /summarize ;

run;

ods pdf close;

[PaigeMiller]

You want to hide the column named RATIO? You could simply exclude it from the COLUMNS statement and don't compute it. Why are you computing it anyway?

[MelissaM]

To clarify: I don't want to hide the ENTIRE column 'ratio'. I only want to display the summary row. I do not want the individual row values to display.

[MelissaM]

I posted below in a document what I "HAVE" and what I "WANT". It might clarify better.

[Cynthia_sas · Accepted solution]

Hi:

  If you take advantage of the automatic variable that PROC REPORT uses internally (_BREAK_), then you can do what you want:

For the border lines you want above the summary, Here are some alternatives:

Hope this helps. Here's a paper about BREAK processing and PROC REPORT. https://support.sas.com/resources/papers/proceedings17/SAS0431-2017.pdf  That should help you understand some of how BREAK processing works.

Cynthia

[MelissaM]

Thank you, Cynthia! This is exactly what I was looking for!