Thanks everyone so much for all the advices!! I tried the below approach and it worked. %LET YEAR = 2016; %LET DATE = '31AUG2016'D; %LET DATE1 = %sysfunc(INTNX(MONTH,&DATE,-1,E)); %LET DATE2 = %sysfunc(INTNX(QTR,&DATE,-1,E)); %LET DATE3 = %sysfunc(INTNX(QTR,&DATE,-2,E)); %LET DATE4 = %sysfunc(INTNX(MONTH,&DATE,-12,E)); %LET DATE5 = %sysfunc(MDY(3,31,&YEAR-1)); %LET DATE6 = %sysfunc(INTNX(MONTH,&DATE5,-12,E)); DATA TEST; SET WAREHOUSE; WHERE AS_OF_DATE IN (&DATE, &DATE1,&DATE2, &DATE3, &DATE4, &DATE5, &DATE6); RUN;
... View more