topic Re: How to find Nth business day incl holidays in SAS Programming

How to find Nth business day incl holidays

Anna_dlC — Tue, 13 Mar 2018 20:47:53 GMT

Our database updates on the 8th business day of the month so I need to create some date parameters that will depend whether or not the current day falls on or before/after the 8th business day.

Just to be clear, I'm just asking for code to identify the 8th business day, not code for creating the date parameters. 🙂

I currently use SAS EG 7.13 and SAS 9.

Re: How to find Nth business day incl holidays

Reeza — Tue, 13 Mar 2018 20:48:36 GMT

You can use TODAY() to generate todays date and then DAY() to get the day of the month.

It's not quite clear what you're looking for besides that.

Re: How to find Nth business day incl holidays

Reeza — Tue, 13 Mar 2018 20:54:39 GMT

business_day = intnx('weekday', intnx('month', today(), 0, 'b'), 8);

If you have custom intervals, which you likely do, you need to build your own custom calendar to account for the holidays and then you can use that interval instead.

Re: How to find Nth business day incl holidays

Anna_dlC — Thu, 15 Mar 2018 13:31:33 GMT

Thanks! I was kind of hoping for a way around the custom calendar thing. I tried a set of code that employed the holiday function but even that had flaws.

But thanks for the tip!

Re: How to find Nth business day incl holidays

Reeza — Thu, 15 Mar 2018 15:01:27 GMT

The custom calendar isn't as hard as it seems though it was intimidating the first time I tried to figure it out.

If you're in US you can use the following to make your holiday lists:

http://www.sascommunity.org/wiki/Generating_Holiday_Lists