topic Re: Customized Summary Lines in PROC REPORT in ODS and Base Reporting

Customized Summary Lines in PROC REPORT

Petersi — Mon, 15 Oct 2007 15:09:07 GMT

When I use a BREAK statement on a group variable, the SUMMARIZE option will create a total for all columns. How do I suppress the summarization of certain columns (such as date values)?

I don't want to use a compute block because that will create one row spanning the entire report. I need the selected summarized values to line up under the appropriate column in excel.

Re: Customized Summary Lines in PROC REPORT

Cynthia_sas — Mon, 15 Oct 2007 15:14:55 GMT

Hi, Peter:
The easiest thing to do is make your DATE variable a usage of DISPLAY. Here's the thing:
[pre]
define mydate / 'My Date';
[/pre]

without any usage on the statement (after the slash) is the same as asking for the SUM statistic of the ANALYSIS usage -- since the date is a numeric variable.

[pre]
define mydate / display 'My Date';
[/pre]

Should prevent the summarization of the date value (so will making it an ORDER or GROUP usage) -- but DISPLAY would be the place to start.

cynthia

Re: Customized Summary Lines in PROC REPORT

Petersi — Mon, 15 Oct 2007 15:27:47 GMT

Thanks Cynthia!