I have a list of around 50 SAS table names within a SAS data set that I would like to query and summarize without typing out 50 different "from" or "set" statements. Is there a way to do this programmatically given the example below? The table names do not necessarily follow a consistent pattern unfortunately. I am using SAS EG 7.15. Thank you for any ideas you may have!   *Example data sets I would like to summarize separately; data TABLE_201901_V3; input store product $ units; datalines; 1 A 10 2 A 20 3 A 20 ; data TABLE_201812_V1; input store product $ units; datalines; 1 A 20 2 A 30 3 A 22 ; data TABLE_201811_V2; input store product $ units; datalines; 1 A 30 2 A 40 3 A 23 ; data TABLE_201709_V1; input store product $ units; datalines; 1 A 40 2 A 50 3 A 25 ; data TABLE_201603_V1; input store product $ units; datalines; 1 A 50 2 A 60 3 A 26 ; *List of the above table names; data sas_table_names; informat tbl_name $char15.; format tbl_name $char15.; input tbl_name $; datalines; TABLE_201901_V3 TABLE_201812_V1 TABLE_201811_V2 TABLE_201709_V1 TABLE_201603_V1 ; *Example of summary information I would like for each table: Where i = a value to differentiate five new data sets and &table_reference = each of the five datalines input data sets; proc sql; create table summary_&i as select distinct product, average(units) from &table_reference group by product; quit; ... View more