BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Badshaah
Obsidian | Level 7
How to find according to month which also contains Hollidays.
1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User

Post all your rules please and a few examples. 

View solution in original post

7 REPLIES 7
PeterClemmensen
Tourmaline | Level 20

what about saturdays/sundays? 🙂

Reeza
Super User

Calendar days, weekdays, or working days? 

 

And what countries holidays? 

 

Have you you looked at INTNX()?

Badshaah
Obsidian | Level 7
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
Super User

Post all your rules please and a few examples. 

Badshaah
Obsidian | Level 7
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
Super User

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
Obsidian | Level 7
Thanks Reeza u r the best...
Grant salute

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 7 replies
  • 2452 views
  • 0 likes
  • 3 in conversation