Is your actual question that you don't know how to write a loop? If so, I would try a DO-loop: %LET YEAR=2015;
%DO MONTH = 1 %TO 12;
PROC SQL;
CREATE TABLE WORKUSI.T01_&YEAR&&MONTH AS
SELECT A.CO_ATM , A.CO_CAU_OPER_ATM, A.CO_SUB_CAU_OPE_ATM , A.DB_OPER
'S' AS FL_CARTA_BANCA, FL_CARTA_POOL ,
SUM( A.IM_OPER_ATM) AS IMP, COUNT (*) AS N
FROM UNI.MOLOGATM&YEAR&&MONTH A
GROUP BY A.CO_ATM , A.CO_CAU_OPER_ATM, A.CO_SUB_CAU_OPE_ATM , A.DB_OPER,
FL_CARTA_POOL;
quit;
%END; you loose the formatting of the month macro variable, but you could write a piece of code that applies the write formatting to month.
... View more