Hi, Here is a qwery, text in red I would like it to be variable by year in the FROM. if the person enters 2020 take the table TABLE2020, if the person enters 2019 that take the table TABLE2019 PROC SQL; CREATE TABLE WORK.QUERY_TABLETEST AS SELECT t1.Ano, (INPUT(t1.IdComuna,BEST32.)) AS ID_COMUNA (SUM(t1.Col01 - t1.Col04 - t1.Col05 )) AS TOTAL FROM TABLE2020 t1 GROUP BY t1.Ano, t1.IdComuna; QUIT; maybe I could explain myself better
... View more