topic Re: How to add a summary to Proc Reports in ODS and Base Reporting

How to add a summary to Proc Reports

Palucci — Tue, 02 Nov 2021 10:59:53 GMT

This is my first time here, I hope that you will help me. I would like to add SUM / MEANS as a summary using Proc Reports. ?The following code does not help me if there is any possibility

proc report data=customer; column date customer ,number_sold define date / group; define customer / across; define number_sold/ mean; define number_sold/ sum; run;

DATE	Customer 1	Customer 2
2021-08	1	95
2021-08	2	77
SUM	3	172
Mean	1,5	86

Re: How to add a summary to Proc Reports

PeterClemmensen — Tue, 02 Nov 2021 11:02:11 GMT

What does your data look like? And what is your desired result?

Re: How to add a summary to Proc Reports

Palucci — Tue, 02 Nov 2021 11:10:45 GMT

At the top, this table is my result that I want to achieve. and the data look the same but without Sum / Median

Re: How to add a summary to Proc Reports

Ksharp — Wed, 03 Nov 2021 12:02:54 GMT

You can't do it in proc report.

Pre-process data before proc report.

proc sql;
create table report as
select 1 as id, put(date,yymmd7.) as date length=20, stock as customer, sum(close) as numer_sold
 from sashelp.stocks
  where date<'01jan1987'd
   group by  calculated date ,stock
union all
select 2,'sum', stock as customer,sum(close) as numer_sold
  from sashelp.stocks
   where date<'01jan1987'd
    group by  stock
union all
select 3,'mean', stock as customer,mean(close) as numer_sold
  from sashelp.stocks
   where date<'01jan1987'd
    group by  stock
  ;
  quit;

proc report data=report nowd;
column id date numer_sold,customer;
define id/group noprint;
define date/group;
define customer/across ' ';
define numer_sold/analysis sum ' ';
run;

Re: How to add a summary to Proc Reports

Kurt_Bremser — Wed, 03 Nov 2021 12:33:11 GMT

I moved this to the "Base Reporting" community. Maybe @Cynthia_sas can chime in with a clever trick.

Re: How to add a summary to Proc Reports

Cynthia_sas — Wed, 03 Nov 2021 16:58:03 GMT

Hi:
You can do what you want to do with PROC REPORT, but it will take some different coding. You are showing your desired results. For CUSTOMER to be used as an across variable, the data has to look different than what you show in your first post. Consider this code and the report it produces. The 19 rows in SASHELP.CLASS are shown with AGE as the GROUP item and with height nested within each value of SEX, which is the ACROSS variable.

If you want to add an extra summary line at the bottom, then you have to do data manipulation like I show in this paper https://support.sas.com/resources/papers/proceedings17/SAS0431-2017.pdf in Example 2, 3, 4 or 5. Probably #5, but without really seeing your actual data, it's hard to guess.

Cynthia