Australian Public Holidays

Reply
Contributor
Posts: 39

Australian Public Holidays

I would be grateful if anybody could share any ideas on how to handle Australian Public holidays and their observed days.  I am trying to code SLA reports that need to exclude public holidays from being counted as working days.  I have started to try and code the logic by creating macro variables using a DATA _NULL_ step and using the HOLIDAY and MDY Functions to create the relevant dates.  However, I am struggling with the logic to take into account observed holidays (i.e. where the public holiday is on a weekend).  Also, wondering if there is an easier way...

Many thanks

Graham

Trusted Advisor
Posts: 1,270

Re: Australian Public Holidays

Hi Graham,

You may find the following sample notes useful to use as a template. Obviously changing the public holidays to Australian ones.

http://support.sas.com/kb/24/655.html

http://support.sas.com/kb/26/044.html

Using the intnx and intck functions are best to use to exclude weekends.

Kind Regards,

Michelle

Ask a Question
Discussion stats
  • 1 reply
  • 286 views
  • 0 likes
  • 2 in conversation