Help with Arrays

[Danglytics]

Hi,

I have a variable set with variables q1_0_on, q1_0_ab, q1_1_on, q1_1_ab ... etc. all the way to q1_12_on, q1_12_ab.

Essentially what i'd like to do is to recode it into a different variable with a scale (1,0,-1) with an array.

q1_0 = 0;

if q1_0_on=1 and q1_0_ab=0 then q1_0=1;

if q1_0_on=0 and q1_0_ab=1 then q1_0=-1 ;

i could duplicate the code above 12 times but i was hoping there's an easy way with an array.

Thanks for your help!

[ballardw · Accepted solution]

Looks like you need 3 arrays.

Array Q_on q1_0_on q1_1_on (continue adding until q1_12_on;

Array Q_ab q1_0_ab q1_1_ab  (ditto);

array Q q1_0 q1_1 ... q1_12;

do i = 1 to dim (Q);

     Q = 0;

     if Q_on=1 and Q_ab=0 then Q=1;

     if Q_on=0 and Q_ab=1 then Q=-1;

end;

drop i;