topic Re: Previous working day in SAS Programming

Previous working day

hhchenfx — Thu, 28 Jul 2022 15:36:18 GMT

Hi Everyone,

I would like SAS to return previous working day.

Can you please help?

Thanks,

HHC

Re: Previous working day

ballardw — Thu, 28 Jul 2022 15:51:54 GMT

Define "working day".

There really is not a universal definition for that. When I was in the US Army every day was a "working day".

If Holidays are to be excluded then which ones, and in which country (some holidays of the same name are celebrated on different calendar dates in different countries).

Re: Previous working day

hhchenfx — Thu, 28 Jul 2022 19:44:30 GMT

Hi,

I meant simple US business day or normal week day.

Thanks,

HHC

Re: Previous working day

PGStats — Thu, 28 Jul 2022 19:58:44 GMT

The basic function is:

prevWeekDay = intnx("WEEKDAY", myDate, -1);

Re: Previous working day

hhchenfx — Thu, 28 Jul 2022 20:09:04 GMT

Thank you so much!

HHC

Re: Previous working day

ballardw — Thu, 28 Jul 2022 21:02:36 GMT

@hhchenfx wrote:

Hi,

I meant simple US business day or normal week day.

Thanks,

HHC

I'll reiterate: there ain't such a thing. If you mean to exclude Federal Holidays on the observed days that's fine, say so but many organization pick and choose which to follow. The SAS Holidayname function returns the names of holidays associated with a given date. So you can test a candidate date to see if it is one of the holidays you expect to observe. If it is then use the INTNX function to get the previous day to test.

When I worked for a University they did not observe Columbus Day or Veterans day.

Many many companies work every day of a typical week and only observe a very few holidays.

A survey company I worked for that typically worked Saturdays would not work on Saturdays that coincided with certain sporting events.