Hi,
@Astounding has given you a good idea there. I would just add that having "data" in table names - or column names - which are for programming purposes is not a good idea. All you are doing is making your programming life harder. If you need separate files then use a consitent prefix and incrementor, for example ds1, ds2 etc. However in most cases, unless your data is huge then having one dataset with a varibale to identify dataset ould be far easier to work with:
data total;
set test1.region_2016: indsname=tmp;
ds_name=input(tranwrd(tmp,"Region_",""),yymmdd8.); format ds_name date9.;
run;
The above will load all the datasets into one dataset called total, and in there you will have a variable with the date from filename. Then you can process this one dataset - no need for looping or knowing lots of file names. You can use by group processing on it. You can use the date data for other calculations etc. Data should go in a dataset, column names and dataset names are there to be used for programming, column labels and dataset labels are there for people to look at.
... View more