Hello,   I am trying to name a column as the previous month, with the year if possible, but at this point just the month would be a big help.  Below is the working code I have, however, this only names the column the current month.    I've tried INTNX but to no avail.    PROC SQL; CREATE TABLE MAP_VALIDATION AS SELECT DISTINCT t1.'MAP_ID'n, (COUNT(t1.MPXN)) AS %sysfunc(today(),monyy7.) FROM ZZ_PRC_OUTPUT t1 GROUP BY t1.'MAP_ID'n; QUIT;   Any help would be MUCH appreciated.  ... View more