Create a custom prompt for year (ie selectedYear) and then use table&selectedYear in your code when you want to reference that table. So your code would become: 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 TABLE&selectedYear t1 GROUP BY t1.Ano, t1.IdComuna; QUIT; Are you familiar with Prompts in EG?
... View more