do loop for matrix

[econfkw]

Attached is the data:

year  Quarter  S1  S2.......S25

The psuedo code is:

do i=1 to 25;

s(i)=1+s(i)/100;

run;

I guess a temp matrix should be rectreated, but I just know how to create a temp vector. My stupid code is:

data s25;

set s25;

1+s1/100;

1+s2/100;

1+s3/100;

1+s4/100;

1+s5/100;

1+s6/100;

1+s7/100;

1+s8/100;

1+s9/100;

1+s10/100;

1+s11/100;

1+s12/100;

1+s13/100;

1+s14/100;

1+s15/100;

1+s16/100;

1+s17/100;

1+s18/100;

1+s19/100;

1+s20/100;

1+s21/100;

1+s22/100;

1+s23/100;

1+s24/100;

1+s25/100;

run;

[shivas · Accepted solution]

Hi,

Try this...not tested.

data test;

set s25;

array _a(25) s1-s25;

do i = 1 to dim(_a);

_a(i)=1+_a(i)/100;

end;

run;

Thanks,

Shiva