topic Sum by group in New SAS User

Sum by group

marleeakerson — Mon, 10 Feb 2020 21:19:38 GMT

Hello,

I am trying to create a table of the sum of observations by grouping. For instance, consider the following data table:

ID X Y

1 10 15

1 7 19

2 10 15

2 11 17

2 35 21

I want the total aggregate sums of X and Y for each ID group.

Thank you!

novinosrin — Mon, 10 Feb 2020 21:26:52 GMT

have you tried Proc summary

proc summary data=have nway;
class id;
var x y;
output out=want(drop=_:) sum=/autoname;
run;

/*or*/


proc sql;
create table want as
select id,sum(x) as sum_x ,sum(y) as sum_y
from have
group by id;
quit;