Hello! I hope this isn't too difficult - but I'm having a hard time working out what I need to do in order to accomplish this: I have a list of tables (for each year) which get created in various parts of my code that are currently hard-coded which I would like to be able to create using a macro (I think) based on a list of years which i determine at the start of my code. The reason for this is I will need to re-run based on updated data and different years in the future and I don't want to have to edit every instance where I have hard-coded years into table creation. For example I have: PROC SQL;
DROP TABLE t_1819, t_1920, t_2021;
CREATE TABLE t_1819
(Group VARCHAR (2)
,Income_band_1819 SMALLINT
,BHC_Frequency DECIMAL (10)
,AHC_Frequency DECIMAL (10)
,BHC_Gross DECIMAL (10)
,AHC_Gross DECIMAL (10)
);
CREATE TABLE t_1920
(Group VARCHAR (2)
,Income_band_1819 SMALLINT
,BHC_Frequency DECIMAL (10)
,AHC_Frequency DECIMAL (10)
,BHC_Gross DECIMAL (10)
,AHC_Gross DECIMAL (10)
);
CREATE TABLE t_2021
(Group VARCHAR (2)
,Income_band_2021 SMALLINT
,BHC_Frequency DECIMAL (10)
,AHC_Frequency DECIMAL (10)
,BHC_Gross DECIMAL (10)
,AHC_Gross DECIMAL (10)
); Is there a way in which I can have a list of years at the start of my code (e.g. 1819, 1920, 2021, ... ) and then one process to create all tables by year in the one go? While also updating columns e.g. 'Income_band_ ...' with each year? I hope that's clear - I'm just not sure what it is that I'm doing here. Many thanks, Michael
... View more