Hi, I wrote a macro that creates macro variables of satistics  from proc NPAR1WAY and then inputs them into a data set called wilcox1 as below.There are 4 statistics wilstatk and pvalk k=1,..,4. For some reason the loop goes all the way to k=5 and and the the resolve functoin tries to resolve &wilstat5 and &pval5 which don't exist. Can anyone tell me what might be causing this? Am I using the %sysfunc(cat() ) correctly?               data wilcox1;                         %do k=1 %to 4;                               %sysfunc(cat(wil_stat,&k)) = resolve('&&wilstat&k');                               %sysfunc(cat(p_val,&k)) = resolve('&&pval&k');                         %end;                         output;             run; Thanks in advance. ... View more

Hi, Can anyone help me with the below error. data _null_; set macro_name(firstobs=1 obs=10); n+1;        call execute('proc reg data=macro_var outest=out EDF; model dPD='||name||'/noprint; run;                               Data _null_;call symput(''NN'','||trim(left(n))||');run;                             Data _null_;set out(keep=_RSQ_ '||trim(left(name))||');                                  call symput(''RSQ'''||&NN||',_RSQ_);                                                                                   WARNING: Apparent symbolic reference NN not resolved.                                                   ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string,                                                  a numeric constant, a datetime constant, a missing value, INPUT, PUT.                          run;'                ); run; I am trying to create 10 macro variables RSQ1,...,RSQ10 with assigned values from table out, sequentially. The error comes when concatenating RSQ with NN which is assigned 1,...,10. If anyone can help on this error that would be great. John   ... View more