Dynamic Sum of Variables

[NN]

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

15

6

9

Thanks In advance

[Tom · Accepted solution]

data want ;

set have;

array a a1-a5;

do _n_=start to end;

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

end;

run;

[Ksharp]

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