add cumulative sum column

[chrisgo]

Need help on creating a sum column by group.

Here's the sample:

group	name	value	want_column
grp1	name1	1	1
grp1	name2	2	3
grp1	name3	3	6
grp1	name4	4	10
grp2	name5	5	5
grp2	name6	6	11
grp2	name7	7	18
grp2	name8	8	26

Thanks,

[stat_sas · Accepted solution]

data want;

set have;

by group;

if first.group then want_column=0;

want_column+value;

run;