topic Re: creating and combing serial tables with macro variables in Statistical Procedures

creating and combing serial tables with macro variables

ammarhm — Sat, 04 Jul 2015 16:26:29 GMT

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 — Sat, 04 Jul 2015 17:12:28 GMT

Replace

%let j=&var-1;

with

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

ammarhm — Sat, 04 Jul 2015 17:50:29 GMT

Thank you PGSats

best regards