data demo;
format date weekdatx. sat_start_of_week fri_end_of_week sat_start_of_year fri_end_of_year date9.;
do date='28dec2013'd to '02jan2026'd;
sat_start_of_week=intnx('week.7',date,0,'b');
fri_end_of_week=intnx('week.7',date,0,'e');
sat_start_of_year=mdy(1,1,year(date)) + mod(11-weekday(mdy(1,1,year(date))),7)-4;
fri_end_of_year=mdy(12,31,year(date))+ mod(10-weekday(mdy(1,1,year(date))),7)-4;
output;
end;
run;
The sat_start_of_week and the fri_end_of_week are in line with the date value.
But for the sat_start_of_year and fri_end_of_year, how can I make sure that 28dec2013 goes from date=28dec2013 until 02jan2015 same thing for 02jan2015
... View more
