Customized Summary Lines in PROC REPORT

[Petersi]

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.

[Cynthia_sas]

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

[Petersi]

Thanks Cynthia!