I want to loop through the following code, for each month up to the current month. So if I ran this today, it would run for Jan (01) and Feb (02), and next month it will do the same, but also for Mar (03), and so on. I can't just do a do loop with I=1 to 12 because the DATE variable below is in the format of mm_2018_01. any suggestions? %MACRO UPDATE_MM(MON=); PROC SQL; create table tmp_&MON as Select DISTINCT * FROM WORK.SOURCE where DATE = "mm_&cu_yr._&mon" ; QUIT; %MEND UPDATE_MM; I think I need to make a list of the month values, as shown below, and do a %do loop, but I'm not quite sure how. %let MONTHS= O1 02 03 04 05 06 07 08 09 10 11 12; %LET TODAY=%SYSFUNC(TODAY(),DATE9.); %LET CU_MO= %Sysfunc( PutN("&TODAY"D, MONTH2 ) ) ;
... View more