((I am making a macro to try to add extra number between 0 to 9 at the end of of certain variabel to make a balance, it's work to get the new variable origtillg to spare the new value, but it's not putting the new value (CATS(i,j) to the previous variabel (i) and not making the correct tabel, what i am missing?, big thanks in advance)) IF SUM(V7200,V7210,V7211,V7212,V7213,V7240,V7250,V7260,V7280) < SUM(V7300,V7320,V7330,V7380,V7381,V7382,V7383) then do; Do i= V7200,V7210,V7211,V7212,V7213,V7240,V7250,V7260,V7280; Do j=0 to 9; if SUM(V7200,V7210,V7211,V7212,V7213,V7240,V7250,V7260,V7280,(-1)*i,CATS(i,j))=SUM(V7300,V7320,V7330,V7380,V7381,V7382,V7383) and i ne 0 then do; origtillg=CATS(i,j) ; i=origtillg; LABEL origtillg=CATS('orig',i); END; END; END; END;
... View more