topic Re: SUM in SAS Programming

SUM

Eric_Johnosn — Wed, 16 May 2018 21:23:32 GMT

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

Re: SUM

novinosrin — Wed, 16 May 2018 21:24:54 GMT

proc sql;

create table want as

select id, sum(amount) as sum

from have

group by id;

quit;

Re: SUM

PaigeMiller — Wed, 16 May 2018 23:47:53 GMT

proc summary data=have;
    class id;
    var amount;
    output out=sums sum=sum_amount;
run;