What ever information we have so far I can suggest following, -Create DATE Array Then -Iterate using loop. Hope that helps Date dataset should b like that to create an array Date1 Date2 dateN Enddate1 Enddate2 EnddateN 21/05/2018 22/05/2018 23/05/2018 24/05/2018 Here is a sample code. you have to make changes as per your dataset array date[n]; array enddate[n]; Do i=1 to n; proc sql; create table test as select variable1, &date.,&endingdate. from table1 where date[n] >= &date. and date[n] <= &endingdate. ;quit; end;
... View more