topic Re: Dynamic Sum of Variables in SAS Procedures

Dynamic Sum of Variables

NN — Mon, 16 Apr 2012 14:36:08 GMT

Hi,

Could someone point me in the right direction for my below requirement..

I wish to take the sum of variables A: based on the values of the variables START and END.

For Example for the first row in the below dataset the Start value is 1 and End Value is 5 hence the sum is to be calculated for the variables A1 to A5.

Data Have;

input START END A1 A2 A3 A4 A5;

CARDS

1 5 1 2 3 4 5

1 3 1 2 3 4 5

2 4 1 2 3 4 5

;

RUN;

The Final Column to be derived is

Thanks In advance

Re: Dynamic Sum of Variables

Tom — Mon, 16 Apr 2012 14:58:21 GMT

data want ;

set have;

array a a1-a5;

do _n_=start to end;

total=sum(total,0,a(_n_));

end;

run;

Re: Dynamic Sum of Variables

Ksharp — Tue, 17 Apr 2012 02:10:25 GMT

Almost the same with Tom's .

Data Have;
input START END A1 A2 A3 A4 A5;
CARDS;
1 5 1 2 3 4 5
1 3 1 2 3 4 5
2 4 1 2 3 4 5
;
RUN;
data want ;
set have;
array a a1-a5;
sum=0;
do _n_=start to end;
   sum+a(_n_);
end;
run;

Ksharp