Hi All, I have Do Loop within a Do Loop and Macro's inside of that. Below is the Sequence. can anyone please help on this ? %MACRO My_Macro_1; %do i = 1 %to 2; <---this loop only execute 1st time, but, does not calling 2nd time - that's the issue and questions proc sql; select One_Variable from Table1; Quit; %My_Macro_2(&Para1.); proc sql noprint; Select ..... Quit; %MACRO My_Macro_3; %do i = 1 %to 47; <---this loop execute 47 times, when i = 1 for outer loop, but, does not calling 2nd time - that's the issue and questions proc sql; select ..... ..... Quit; %My_Macro_4(&Para2.); %end; %MEND My_Macro_3; %My_Macro_3; %end; %MEND My_Macro_1; %My_Macro_1;
... View more