@Yakatan wrote: Yes, so your solution has allowed me to get to the value of the variables i need, what i was now wanting to do was to reference those values at a later step. I am going to be applying my logic to a dataset that has more than 10million rows, so i didnt want to have to create additional data if i could help it, hence why i thought it would be better to use a macro variable. Similarly i may be require to have numerous start dates which mean i would be potentially creating quite a lot of additional data. When i speak about the 6th iteration i was referring to the output creating from your solution when i=6.
I think we are talking around in circles. Everything you say, in my opinion, indicates you need to use DATA steps and not macros.
Using DATA steps as I showed earlier on your very small sample doesn't have to enlarge the size of the resulting data set, you can drop the variables you don't want (in my earlier code this would be variables first_day_of_month and desired_day) and thus the data set does not grow bigger.
... View more