Hi, I am trying to run a MACRO step to output multiple datasets based on the dates. However, I can't seem to figure out how to mend the dates and create unique table names: %macro duo(rptmth); proc sql; create table P&rptmth as select * from dataset where reportdate GE intnx('month',&rptmth.d,-12) and reportdate LT intnx('month',&rptmth.d,1) quit; %mend duo; %duo('01Sep2015'); %duo('01May2015'); Thanks, Jeff
... View more