All, I have seen and read many resources on date manipulation in SAS format specifically, but they have not helped me with this issue at work. I have tried the Sysevalf and the Intnx feature and neither seem to give me what I am looking for. If anyone can shed some light on this I would be very grateful. Simply put, I am trying to create a set of macros to use in an SQL step which all feed off of one date versus typing in each date separately. Currently I have the below... %let Related_Act_Date1 = 201212; %let Related_Act_Date2 = 201301; %let Related_Act_Date3 = 201302; %let Related_Act_Date4 = 201303; %let Related_Act_Date5 = 201304; %let Related_Act_Date6 = 201305; %let Related_Act_Date7 = 201306; %let Related_Act_Date8 = 201307; %let Related_Act_Date9 = 201308; %let Related_Act_Date10 = 201309; %let Related_Act_Date11 = 201310; %let Related_Act_Date12 = 201311; %let Related_Act_Date13 = 201312; /*current month*/ Ideally I would like to just type in the current month and have all the others feed from that versus typing them in monthly. This list is much longer, but I have only copied what is hopefully necessary to get my question across. Hopefully you can see how big of a pain it is to change these every month. I need to keep this format YYYYMM and day is not needed. Can anyone shed some light on this by chance? Thanks so much!
... View more