Along with this, The Dates are arrange week wise for only next 53 Week including current week , As current week should be consider as WEEK1(Monday-Sunday). I tried something below code to figure out next 53 weeks, options symbolgen mprint mlogic; %macro Week; data m1; %do i=0 %to 52; SHPDT=today(); put SHPDT=; WeekStart=intnx('week', SHPDT, &i,'b')+1; WeekEnd=intnx('week', SHPDT, &i,'e')+1; format SHPDT WeekStart WeekEnd date9.; drop SHPDT; output; %end; run; %mend week; If you could suggest coding approach to integrate the existing code with this requirement.
... View more