creating and combing serial tables with macro variables

[ammarhm]

Hi all

Can anyone please advice me how to correct this code, I am basically trying to create and combine serial tables

%macro repeat_comb(levels=);

%do var=1 %to &levels;

%let j=&var-1;

proc sql;

create table s&var as

select a.*,b.flag as L&var

from s&j as a

left join tableD as b

on a.class like b.L&var;

quit;

%end;

%mend;

%repeat_comb(levels=8)

The problem is in creating the second variable (j) and using it to refer to tables s&j which is returing error

Best regards

[PGStats · Accepted solution]

Replace

%let j=&var-1;

with

%let j=%eval(&var-1);

PG

[ammarhm]

Thank you PGSats

best regards