topic Re: How find last 3 days of month in SAS Programming

How find last 3 days of month

Badshaah — Thu, 01 Dec 2016 07:28:39 GMT

How to find according to month which also contains Hollidays.

Re: How find last 3 days of month

PeterClemmensen — Thu, 01 Dec 2016 07:36:55 GMT

what about saturdays/sundays? 🙂

Re: How find last 3 days of month

Reeza — Thu, 01 Dec 2016 07:41:40 GMT

Calendar days, weekdays, or working days?

And what countries holidays?

Have you you looked at INTNX()?

Re: How find last 3 days of month

Badshaah — Thu, 01 Dec 2016 07:45:06 GMT

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)

Re: How find last 3 days of month

Reeza — Thu, 01 Dec 2016 07:47:43 GMT

Post all your rules please and a few examples.

Re: How find last 3 days of month

Badshaah — Thu, 01 Dec 2016 07:53:01 GMT

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

Re: How find last 3 days of month

Reeza — Thu, 01 Dec 2016 11:57:21 GMT

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;

run;

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

Re: How find last 3 days of month

Badshaah — Thu, 01 Dec 2016 12:35:57 GMT

Thanks Reeza u r the best...
Grant salute