Hi, Any help would be much appreciated! I am trying to automate a report that runs monthly, with a one month 'lag' and creates a variable in where the values are in single quotes. So, for example, if I run the report today, it creates a variable that reads '01MAY2013' single quotes included. I am able to create the macro variable that creates the variable by creating this: %let report_month =%sysfunc(intx(month.1,"&sysdate"d,-1),MonYY7.); i just can't figure it out how to get the date in quotes such that it in the format '01MAY2013' d. Thanks in advance!
... View more