I apologize, i need to clarify the problem. The data is in a table in the data warehouse (it has over a million rows per load date). In order to prevent extracting over 45 million rows of data per month, i wanted to use the approach below. I used a macro to create dates (within the dates mentioned), then go through 1 iteration of PROC SQL statement per date to identify field changes for entire year. I hope that clarified your question. %macro date_loop(start,end); %let start=%sysfunc(inputn(&start,anydtdte9.)); %let end=%sysfunc(inputn(&end,anydtdte9.)); %let dif=%sysfunc(intck(day,&start,&end)); %do i=0 %to &dif; %let date=%sysfunc(intnx(day,&start,&i,b),date9.); %put &date; %end; %mend date_loop; %date_loop(01may2017,05may2017); proc sql; create table xyz as (select * from table1 where FILE_SEND_DT = &start + 1 except select * from table1 where FILE_SEND_DT = &start); quit;
... View more