Looping or using array within Proc sql

[q5pham]

Hi ChrisNZ,

I would like to use your code in a similar case, but I got errors. The tast is simply to scale down all columns (numeric format), except the first, by 100. Could you please help to correct for me. Thank you very much. Mai

proc contents
data = MP
out = test (keep = name varnum);
run;
proc sql ;
    select distinct name
     into : varlist separated by ' ' from test
    where varnum not in (1),
              %macro loop; %local i varname; %do i=1 %to dim(&varlist); %let varname=%scan(&varlist,&i);
        ,(&varname/100) as &varname
              %end; %mend; %loop
     from test

quit;

[ChrisNZ]

@q5pham Turn on option mprint then look at the invalid SQL query you are generating. The issue should become obvious.

[q5pham]

Thank you all very much for your quick and efficient replies.