About jeattberg

jeattberg · ‎02-15-2018

Thank you so much, this solution worked great. I did not know you could use the %sysfunc equation as part of a variable name, so I learned something new about DO loops and that as well.

jeattberg · ‎02-14-2018

I understand up to this point, I've found a couple ways to generate a list from 01 to current month, but how do I use that dynamic list to loop through my macro code. That's where I'm getting stuck. Thank you so much for your help!

jeattberg · ‎02-14-2018

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 ) ) ;

Online Status	Offline
Date Last Visited	‎03-05-2020 06:37 PM

Re: Creating a variable list to loop through macro

Re: Creating a variable list to loop through macro

Creating a variable list to loop through macro

Re: Creating a variable list to loop through macro

Re: Creating a variable list to loop through macro

Creating a variable list to loop through macro