topic Re: SAS macro: First and last working day of previous week in SAS Programming

SAS macro: First and last working day of previous week

Sid_Chaurasiya — Tue, 09 Apr 2019 06:18:03 GMT

Hi Guys, I use this code to get the date of Monday and Friday from previous week -

%let first_day=%sysfunc(intnx(week.2,%sysfunc(today()),-1,b),date9.);
%put first_day=&first_day ;

%let last_day=%sysfunc(intnx(week.6,%sysfunc(today()),0,b),date9.);
%put last_day=&last_day ;

The macro is usable for most weeks, except when there's a holiday on Monday or Friday. How can I get the next working day if there's a holiday on Monday and previous working day if it is a holiday on Friday?

Re: SAS macro: First and last working day of previous week

SASKiwi — Tue, 09 Apr 2019 07:59:02 GMT

Holidays vary from country to country, state to state, province to province, and even from business to business. Where I live and with the business I work in - banking - we ignore provincial holidays but count national ones as far as "business" days are concerned.

The only sure way of dealing with this is to create your own holidays dataset for your particular location and use that to derive what you want.