topic how to sum within column with 2 sorting variables? in SAS Procedures

how to sum within column with 2 sorting variables?

bluetail — Sun, 07 Aug 2011 15:07:56 GMT

Hello,

Suppose i have such dataset :

date id res sumres

1 a 10

1 a 15

1 a 10 35

2 a 12

2 a 8

2 a 10 30

1 b 10

1 b 17

1 b 12 39

;

I need to calculate these sumres (35, 30, 39....) in a new dataset which are for id=a and date=1, for id=a and date=2, id=b and date=1, id=b=2 and so on... i have dates from 1...30.

its probably a loop, if first.date=....do;..but cant figure it out.

anyone knows how to do it? i'd be immesely grateful.

cheers,

how to sum within column with 2 sorting variables?

art297 — Sun, 07 Aug 2011 15:23:45 GMT

If your data are EXACTLY as shown, and you really only want the sumres calculation to be non-missing for the last record in each set, then it is easy. I don't have access to SAS to test the following code at the moment, but it should give you enough of an idea to solve your problem.

data want (drop=calculation);

set have;

by id date;

if first.date then calculation=res;

else calculation+res;

if last.date then sumres=calculation;

run;

how to sum within column with 2 sorting variables?

bluetail — Sun, 07 Aug 2011 15:56:49 GMT

art297, thank you for a quick reply - you're a star! i tried it before but missed out the ' if last.date' part