I have a very large dataset with over 1000 columns, with column names formatted like this: WORLDDATA.table2_usa_2017_population
WORLDDATA.table2_japan_2017_gnp I only need to keep a subset of these parameters for a select few countries. I specify the custom lists: %let list1 = usa canada uk japan southafrica;
%let list2 = population crimerate gnp; How do I do a double for loop like so: param_list = []
for (i in list1) {
for (j in list2) {
param_name = WORLDDATA.table2_{list1[i]}_2017_{list2[j]}
param_list.append(param_name)
}
} such that I can use param_list in data final_dataset;
set WORLDDATA.table2;
keep {param_list};
run; Thank you!
... View more