Help using Base SAS procedures

do loop for matrix

Accepted Solution Solved
Reply
Contributor
Posts: 23
Accepted Solution

do loop for matrix

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;

Attachment

Accepted Solutions
Solution
‎09-15-2012 05:05 AM
Super Contributor
Posts: 349

Re: do loop for matrix

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

View solution in original post


All Replies
Solution
‎09-15-2012 05:05 AM
Super Contributor
Posts: 349

Re: do loop for matrix

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

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 152 views
  • 0 likes
  • 2 in conversation