It's actually very easy. Assuming you already have a reporting date defined as a SAS date in your data this is how you do it - Reporting_Month is the counter:
data want;
set have;
Reporting_Month = intck('MONTH', today(), Reporting_Date);
run;
... View more