Thank you very much. You totally understand where I am coming from unlike other posters here. I think I understand your code logic, although still a bit complex for me I will try to find out what all the statements mean. But I think your code works. Thank you very much! ... View more

thanks but i have to run this for like 36 months, so i can't just append it like that.    I have to run my macro 36 times for each year month parameter. That is why I am trying to find it to run on a loop and append the results.  ... View more

I do have macro code that works, but that's not what is important here as I said the problem isn't getting it to work. it is appending the output tables. That is why I didn't include the code for the macro. ... View more

The macro code works fine when i put in values for the parameters such as 202202, 202203, 202204. But my question is how to do I append these tables in a loop?  there's no way to loop the dates so it goes from 202101 to 202203?    I found something on stack overflow that says to do this:   %macro loop(start_month=, stop_month=); %local month; %do month=&start_month %to &stop_month; %put Month: &month; %* SQL CODE HERE.... %* SPECIAL CASE WHEN WE REACH END OF A YEAR; %if %substr(&month, 5, 2) = 12 %then %let month = %eval(&month + 88); %end; %mend loop; %loop(start_month=200301, stop_month=201502)  but when i plug in my macro in the middle  %yearmonth(&YM); it doesn't work.  Do you know why? %macro loop(start_month=, stop_month=); %local month; %do month=&start_month %to &stop_month; %put Month: &month; %yearmonth(&YM); %if %substr(&month, 5, 2) = 12 %then %let month = %eval(&month + 88); %end; %mend loop; %loop(start_month=202101, stop_month=202203)   ... View more