DATA Step, Macro, Functions and more

SUM

Reply
New User
Posts: 1

SUM

Hello I have a dataset with the below.  I would like to sum the amounts by ID's, but when I try traditional proc sql it will sum the entire amount column and put it into the value for each id.  

ID's     amounts

1         1

1         2

1        3

1        4

2         1

2         2  

2        3

2         4

3        1 

3         2

3        3

3       4

3        5

Super User
Posts: 2,075

Re: SUM

Posted in reply to Eric_Johnosn

proc sql;

create table want as

select id, sum(amount) as sum

from have

group by id;

quit;

Respected Advisor
Posts: 3,293

Re: SUM

Posted in reply to Eric_Johnosn
proc summary data=have;
    class id;
    var amount;
    output out=sums sum=sum_amount;
run;
--
Paige Miller
Ask a Question
Discussion stats
  • 2 replies
  • 105 views
  • 2 likes
  • 3 in conversation