topic Re: proc report: add individual summarized rows in SAS Programming

proc report: add individual summarized rows

Konkordanz — Fri, 16 Sep 2022 11:07:07 GMT

Hi,

with the proc-report-command i´m able to summarize groups with the break-command. But with this command it creates new summarized lines for all groups (for exampe: 4 groups). But what, if I want this summarized rows only for 1 of them? Is this doable? Something like..."summarize all values of row 1-4 and write it in row 5"...

Thank you!

Re: proc report: add individual summarized rows

PaigeMiller — Fri, 16 Sep 2022 11:17:04 GMT

@Konkordanz wrote:

Hi,

with the proc-report-command i´m able to summarize groups with the break-command. But with this command it creates new summarized lines for all groups (for exampe: 4 groups). But what, if I want this summarized rows only for 1 of them? Is this doable? Something like..."summarize all values of row 1-4 and write it in row 5"...

Sorry but I'm not grasping how what you are asking for is different than the break command. Can you please show us a small example, or explain in more detail?

Re: proc report: add individual summarized rows

Konkordanz — Mon, 19 Sep 2022 07:01:13 GMT

Sorry for the lack of explanation. For example, here the have-dataset:

Size	bev
2	10
3	20
10	30
11	40
12	60
13	50
14	40
15	30
16	90
33_34	30
40_41	20

No I want two new rows.

Row 1: This one should appear before Size 2 with the sum of Size 2 and 3.

Row 2: This one should appear before Size 10 with the sum of size 10-16.

The result is want:

Size	bev
newLine1	30
2	10
3	20
newLine2	340
10	30
11	40
12	60
13	50
14	40
15	30
16	90
33_34	30
40_41	20

So: I need the rows only for Size = 2,3 and Size=10,11,12,13,14,15,16. The size 33_34 and 40_41 shouldnt get a line.

My question is: Is it within the proc-report-command doable?

Re: proc report: add individual summarized rows

PaigeMiller — Mon, 19 Sep 2022 10:24:17 GMT

I am not grasping how the programmer knows which records bet summed together into a group, and which records not to sum, what is the rule?

If you want sums ABOVE the rows with the data, you would have to create a data set somehow with everything in the right order including sums above the data to be summed, and then use PROC REPORT on that.