I need help in this code:
My code:
%macro do_mean1;
%do L = 1 %to &maxid;
%do P = 2 %to &maxid;
proc sql;
create table a&P as
select step&P..LOT,step&P..XIND,step&P..YIND
from step&P, step&L
where step&P..LOT eq step&L..LOT and step&P..WF eq step&L..WF;
quit;
proc append base=comb1 data=a&P force;
run;
%end;
%end;
%mend do_mean1;
%do_mean1
Explanation: MAXID is the macro variable.
Problem: Suppose, the value of maxid is 15.
So for L = 1 - it runs for P = 2 to 15
L = 2 - it runs for P = 2 to 15
L= 3 - it runs for P = 2 to 15.
So, How to increment the value of P every time when we get new value of L??
Desired output:
L = 1 - it should run for P = 2 to 15
L = 2 - it should run for P = 3 to 15
L= 3 - it should run for P = 4 to 15.