Sum by group

[marleeakerson]

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]

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;