Hello, proc sql; create table table_2 as select * from table_2022  (I want the table name to change automatically compared to 3.6 and 12 months ago.) where year = 2022 and month = 08; (I want these fields to come automatically.)     proc sql; create table table_1 as  select * from table_2023 (I want the table name to change automatically compared to 3.6 and 12 months ago.) where year = 2023 and month in (05,03)  (I want these fields to come automatically.)   I can give an example like that. I dont want to write year and month manuel. Would we try to write it like symput? As each month changes, I want the month variables in the where constraint to change from manual to automation. Can we write this in one set instead of writing two different sets of code? ... View more

Hi, I want to change my table name with if conditions. To give an example, there are tables specific to each year. I'm trying to pull data from 3.6 and 12 months ago. but i ran into a problem. Assuming that I do April 2023 analysis, I can use table_2023 belonging to the year 2023 3 months ago, but since it belongs to the year 2022 6 and 12 months ago, I want the from part to be assigned automatically in proc sql. I can summarize as follows. proc sal; create table AAA as select * from table_2023 where sysmonth - 3 run; ... View more