see if the following is what you are looking for. data test; input m $ v $ s $; datalines; V1 M1 S1 V2 M1 S1 V3 M1 S1 V4 M2 S2 V5 M2 S2 V6 M2 S2 V7 M3 S3 ; run;

%macro test(m, v, s); %put &m &v &s; %mend;

data _null_; do until (eof); set test end = eof; call execute('%test('||m||', '||v||', '||s||')'); end; run;

On 5/4/07, manotickgirl@gmail.com <manotickgirl@gmail.com> wrote: > Hello, > I have a table: > V1 M1 S1 > V2 M1 S1 > V3 M1 S1 > V4 M2 S2 > V5 M2 S2 > V6 M2 S2 > V7 M3 S3 > ... > > I have a macro that accepts parameters V&i, M&i, S&i and uses them in > a formula. > My goal is to form variables V&I, M&i, S&i in a loop: i=1 to n. > Is it possible to do smth like this: > > data _null_; > do i=1 to &n; > V=cat('V',i); > if (i) in &subj then do; > counter+1; > m=cat('m',counter); > s=cat('s',counter); > call symput('V',V); > end; > %macro2(V,M,S); > > end; > run; > > Or: > > %macro macro1; > %do i=1 %to &n; > V=V&i; > %if (&i-1) in &subj %then %do; > &counter+1; > m=m&counter; > s=s&counter; > %macro2(V,M,S); > %end; > run; > %mend macro1; > > I get errors in both cases. > > Please, help me. >

-- WenSui Liu A lousy statistician who happens to know a little programming (http://spaces.msn.com/statcompute/blog)