options symbolgen mprint; %macro loop; %do i=1 %to 10; proc sql; create table &&ParamList&i.._data as select * from Prod.&&ParamList&i.._DATA; quit; data &&ParamList&i.._data; set &&ParamList&i.._data; Run=%str(%'&&ParamList&i%'); %end; %mend; %loop; data xyz_data_data; set xyz_data; runs='xyz'; run;