topic PROC REPORT: How to hide cells from report in SAS Procedures

PROC REPORT: How to hide cells from report

MelissaM — Tue, 18 Aug 2020 12:51:55 GMT

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;

Re: PROC REPORT: How to hide cells from report

PaigeMiller — Tue, 18 Aug 2020 13:03:55 GMT

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?

Re: PROC REPORT: How to hide cells from report

MelissaM — Tue, 18 Aug 2020 14:06:08 GMT

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.

Re: PROC REPORT: How to hide cells from report

MelissaM — Tue, 18 Aug 2020 14:13:23 GMT

Re: PROC REPORT: How to hide cells from report

MelissaM — Tue, 18 Aug 2020 14:14:42 GMT

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

Re: PROC REPORT: How to hide cells from report

Cynthia_sas — Tue, 18 Aug 2020 17:51:06 GMT

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

Re: PROC REPORT: How to hide cells from report

MelissaM — Thu, 20 Aug 2020 00:48:31 GMT

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