topic Re: Meaning of 2nd argument to HOLIDAYNAME function in SAS Programming

Meaning of 2nd argument to HOLIDAYNAME function

PaigeMiller — Thu, 19 Dec 2019 13:07:22 GMT

What does the second argument to the HOLIDAYNAME function do? The documentation is basically non-explanatory here. It says "N specified the index". No further explanation about what the index does.

I have to say that usually, SAS documentation is excellent, but here it falls flat on its face.

Re: Meaning of 2nd argument to HOLIDAYNAME function

novinosrin — Thu, 19 Dec 2019 13:22:03 GMT

Good morning Sir @PaigeMiller Thank you for the excellent question. Here is my guess on reviewing the example in the documentation

data a;
   length Holiday $32;
   format date weekdatx17.;
   do year=2000 to 2010;
      date=mdy(11,11,year);
      ObsVetNov11=holidaycount(date);
      do index=1 to ObsVetNov11;
         Holiday=holidayname(date,index);
         output;
      end;
   end;
run;

Apparently the index refers to the same day i.e if holiday is being referred to more than one holidayname. The index number seems to provide that unique internal lookup identifier that fetches distinct holidaynames for the same date. As the program computes the hoildaycount, which is used in nested loop, my thought process invariably points to that understanding.

For example, British dominions have boxing day and the same has different names in different countries.

My 2 cents!

Re: Meaning of 2nd argument to HOLIDAYNAME function

PaigeMiller — Thu, 19 Dec 2019 13:51:12 GMT

That's a very good explanation @novinosrin and probably correct, but it still leaves me unable to use this argument as I don't know what the meanings of index=1 and index=2 and index=3 are, and what all the possible results are from the HOLIDAYNAME function.

Again, a horrible failure of the documentation.

Re: Meaning of 2nd argument to HOLIDAYNAME function

novinosrin — Thu, 19 Dec 2019 14:12:16 GMT

Yes true and I agree. SAS Inc should have a LOOK-UP reference file. And considering, SAS a global company, the LOOK UP reference file for holidays should account for all countries where SAS operates.

Re: Meaning of 2nd argument to HOLIDAYNAME function

PaigeMiller — Thu, 19 Dec 2019 14:16:27 GMT

Perhaps I should ask a broader question ... I want to identify holidays, not only this year but perhaps several years in the future or past. What is a good method to do this? With HOLIDAYNAME() I can identify not only THANKSGIVING and PRESIDENTS day in the US, but I can also ignore other holidays not relevant to my project such as HALLOWEEN.

Re: Meaning of 2nd argument to HOLIDAYNAME function

unison — Thu, 19 Dec 2019 16:08:06 GMT

It looks like the index allows you to discern between different holidays that have fallen on the same date.

In @novinosrin's example, Veteran's day is observed in three different holiday schemes: Julian/calendar, US Gov., Postal (USPS). The index is somewhat unpredictable for holidays that depend on whether or not the true calendar day falls on a weekend (US Government holidays will always fall on a weekday -- fantastic if you work in the Public sector :)). See here:

data test;
   length holiday $32;
   format date weekdatx17.;
   do date='01jan2017'd to '31dec2019'd;
      cnt=holidaycount(date);
      do index=1 to cnt;
         holiday=holidayname(date,index);
         if holiday in ('VETERANS' 'VETERANSUSG') then output;
      end;
   end;
run;

If you want only specific holiday dates for a given time range, you might scan across the years of interest and then pull out the holidays you want by name.

-unison

Re: Meaning of 2nd argument to HOLIDAYNAME function

ballardw — Thu, 19 Dec 2019 16:09:11 GMT

@PaigeMiller wrote:

Perhaps I should ask a broader question ... I want to identify holidays, not only this year but perhaps several years in the future or past. What is a good method to do this? With HOLIDAYNAME() I can identify not only THANKSGIVING and PRESIDENTS day in the US, but I can also ignore other holidays not relevant to my project such as HALLOWEEN.

Maybe the HOLIDAYNX function would help. This examples gets the next 10 Thanksgiving dates relative the to first of October in 2019.

data example;
   do i=1 to 10;
      thxdate= holidaynx('Thanksgiving','01OCT2019'd,i);
      output;
   end;
   format thxdate date9.;
run;

I picked Thanksgiving since the date move a bit.