I want to add a column to an existing data table in a macro step. I've already connected to a database and extracted the files of interest. The filename contains the specific lot ID but it is no where in the data table itself. So, I want to create a new column that contains the lot designation. In the snippet below, the sql portion works fine but the subsequent data step doesn't. More specifically, the part that fails is passing the macro variable in the data steps. Any help would be greatly appreciated. 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; Lot_ID=%str(%'&&ParamList&i%'); /* Here's where the issue is */ %end; %mend; %loop; The following works but it's comp[lately manual... data xyz_data; set xyz_data; runs='xyz'; run;
... View more