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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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