Insert rows based on group ID and difference in sum

SP01 — Sun, 13 Nov 2022 15:10:40 GMT

Hello SAS community,

I have a problem where I would appreciate your time and help.

Let's say I have data A with group ID 'A' and the total sum of the group ID 'A' is 11. I have another data B with the same group ID 'A' and the total sum of the group ID 'A' is 20. Now the difference is 9, I want to expand this difference of 9 into 9 rows by that group ID 'A' and /append/insert into data A. I have put the tables for your reference.

data A

Group	Sum
A	1
A	3
A	4
A	1
A	2
Total	11

data b

Group	Sum
A	5
A	2
A	3
A	5
A	5
Total	20

expand the difference of 9 into rows

Group	Count
A	1
A	1
A	1
A	1
A	1
A	1
A	1
A	1
A	1

data want

Group	Sum
A	1
A	3
A	4
A	1
A	2
Total	11
A	1
A	1
A	1
A	1
A	1
A	1
A	1
A	1

SAS peeps, I really appreciate and thank you for your time and help on this.

Re: Insert rows based on group ID and difference in sum

PeterClemmensen — Mon, 14 Nov 2022 18:52:01 GMT

A few things.

Why?
You seem to have only 8 obs appended to your original data? Is that an error?
Are there always 2 data sets or could there be more? And are there more than 1 group in your data sets?

topic Insert rows based on group ID and difference in sum in SAS Programming

Insert rows based on group ID and difference in sum

Re: Insert rows based on group ID and difference in sum