hello i want to create a macro that takes current date and number of loopback months as input and create a series of macro variables capturing last day of each month example: curr_dt: 20141224 number of look back months (n) =6 The output should be (6 statements to create 6 variable names) %let date_1=sysfunc(intnx('month',-1,inputn(curr_dt,mmddyy6.),e),yymmddn8.); %let date_2=sysfunc(intnx('month',-2,inputn(curr_dt,mmddyy6.),e),yymmddn8.) . . . %let date_6=sysfunc(intnx('month',-6,inputn(curr_dt,mmddyy6.),e),yymmddn8.) Thanks vminc
... View more