How find last 3 days of month

[Badshaah]

How to find according to month which also contains Hollidays.

[PeterClemmensen]

what about saturdays/sundays? 🙂

[Reeza]

Calendar days, weekdays, or working days? 

And what countries holidays? 

Have you you looked at INTNX()?

[Badshaah]

Code required according to indian holiday
If last day is Saturday or Sunday or any holiday then they don't consider as last day else last day(only last 3 days of months)

[Reeza · Accepted solution]

Post all your rules please and a few examples. 

[Badshaah]

Rules
1) only last 3 days of each month ,monthend flag get 1 and rest of dates it will be 0

2) if it's Saturday,Sunday,Hollyday (or combination of those ) then monthend flag get 1

[Reeza]

Data want; 

do year=2006 to 2016;

do month=1 to 12;

date=MDY(month, 1, year);

do i=1 to 3;

date=intnx('month', date, 0, 'e') + 1 - i;

if weekday(date) in (1,7) or date in ( list of holidays) then not_working=1;

else not_working=0;

if i=1 then month_end =1; else month_end=0;

end;

end;

end;

run; 

You will need to have a list of your holidays to verify holiday dates. 

[Badshaah]

Thanks Reeza u r the best...
Grant salute