The SAS Output Delivery System and reporting techniques

Customized Summary Lines in PROC REPORT

Reply
Contributor
Posts: 20

Customized Summary Lines in PROC REPORT

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.
SAS Super FREQ
Posts: 8,743

Re: Customized Summary Lines in PROC REPORT

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
Contributor
Posts: 20

Re: Customized Summary Lines in PROC REPORT

Thanks Cynthia!
Ask a Question
Discussion stats
  • 2 replies
  • 132 views
  • 0 likes
  • 2 in conversation