topic Proc Report - creating output of summary lines in SAS Procedures

Proc Report - creating output of summary lines

deleted_user — Thu, 07 Jan 2010 16:51:54 GMT

Hi everyone,

I need to create an output report of only the summary lines created in Proc Report. What code will accomplish this?

Thanks!

Re: Proc Report - creating output of summary lines

sbb — Thu, 07 Jan 2010 18:19:55 GMT

Suggested Google advanced search argument to consider based on your post's topic area:

proc report group summary site:sas.com

Re: Proc Report - creating output of summary lines

Eva — Fri, 08 Jan 2010 15:55:33 GMT

Hi Shell,

do a proc summary first which returns one single row.

Best regards
Eva

Re: Proc Report - creating output of summary lines

deleted_user — Fri, 08 Jan 2010 18:29:19 GMT

Thanks Eva,
I'll try that.

Shelley

Re: Proc Report - creating output of summary lines

Cynthia_sas — Fri, 08 Jan 2010 19:15:51 GMT

Hi:
PROC REPORT has the ability to produce either GROUP (summary) or ORDER (detail) reports.

For example, this code:
[pre]
proc report data=sashelp.shoes nowd;
column region subsidiary sales;
define region / order;
define subsidiary / order;
define sales/ sum;
break after region / summarize;
run;
[/pre]

In the above report, I would see a detail line for every observation, ordered by region/subsidiary, with a summary line underneath every region. For example, if the dataset has 500 observations, I would have at least 500 report rows. If I have 10 regions in the data, then the detail report would also have 10 summary lines.

If I ONLY want to see the REGION information -- or 10 summary lines for each REGION, then the above code needs to drop subsidiary and change the usage for REGION to GROUP:
[pre]
proc report data=sashelp.shoes nowd;
column region sales;
define region / group;
define sales/ sum;
rbreak after / summarize;
run;
[/pre]

Now, I will only see the summarized sales for each region, without any detail lines coming from the subsidiary information.

Or, you could use other procedures, like PROC MEANS or PROC SQL to "pre-summarize" the data and then pass the summary info to PROC REPORT. This does, however, require 2 passes through the data -- which isn't too horrible for small to medium datasets, but really unnecessary, when PROC REPORT will do it in one step...summarizing and reporting.

cynthia

Re: Proc Report - creating output of summary lines

deleted_user — Mon, 11 Jan 2010 16:49:46 GMT

Thank you for including details, Cynthia!