So i wanted to create a macro with a loop. Basically what the macro would do is loop through for a certain number of days. The program is made up of a few parts, first a temporary table is created with the data using create table, then i have a code for it to be stored into the DB. I need the macro to loop through it for a X number of days. %Macro....; %do i=to to &.. proc sql; creat table... proc sql; create table.. data_Null; set work... proc sql no print; run; %end %mend datastorage This would be the structure of it. However i keep getting the error of   ERROR: The following columns were not found in the contributing tables: i. Can someone explain to me if this is possible and what i am doing wrong? ... View more