So, with the of a bit of documentation and google I managed to help myself with this code:
/*create a base empty table*/
PROC SQL;
CREATE TABLE WORK.teste_new AS
SELECT DISTINCT
. as month,
. as year,
. as PAID_AMMOUNTS,
. as COSTS
from ZDRGTI.SVIS_CONTROL_FSCD_&delta_1 t1
where t1.DATA_EXTRACCAO is missing;
QUIT;
%macro sqlloop(start,end);
PROC SQL;
/* the loop*/
%DO delta=&start. %TO &end.;
/*the code*/
CREATE TABLE WORK.teste_new AS
SELECT
month(t1.DATA_EXTRACCAO) as month,
year(t1.DATA_EXTRACCAO) as year,
sum(t1.PAID_AMMOUNTS) as PAID_AMMOUNTS,
sum(t1.COSTS) as COSTS
FROM ZDRGTI.SVIS_CONTROL_FSCD_&delta t1
where PK contains 'GIS|67'
group by calculated month, calculated year
OUTER UNION CORR
SELECT * FROM WORK.teste_new;
%END;
QUIT;
%mend;
%sqlloop(start=&delta_1,end=&delta_2)
Thanks for the help guys
... View more