Date: Wed, 12 Dec 2007 15:54:28 -0800
Reply-To: "Schwarz, Barry A" <barry.a.schwarz@BOEING.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Schwarz, Barry A" <barry.a.schwarz@BOEING.COM>
Subject: Re: How to etermine if date is a holiday
Content-Type: text/plain; charset="us-ascii"
Do you want the legal date of the holiday or the date it is observed?
Do you want federal holidays or bank holidays or stock market holidays?
From: Tom White [mailto:snip]
Sent: Wednesday, December 12, 2007 3:22 PM
Subject: How to etermine if date is a holiday
I have a data set with millions of records.
One of the fields is a date field tah takes on values like 17AUG2005,
etc. (All date values have this format.)
I would like to cretae another column next to the date column and for
each record, decide if the date is a holiday or not.
MYDATE HOLIDAY_DATE HOLIDAY_NAME
01JAN1990 YES (New Years Day)
23NOV2006 YES (Thanksgiving Day)
12DEC2007 NO .
30MAY2011 YES (Memorial Day)
25DEC2010 YES (Christmas Day)
01JAN2004 YES (New Years Day)
31DEC2007 NO .
You get the idea.
I think the major holidays we have are:
New Years Day
New Years Day
Maybe there are a few other non-major holidays.
If SAS can produce those as well, that would be great but I don't know
of any other minor holidays.
I only know of the above major ones.
May be there is a Luther King Day, etc.
The field I show above, HOLIDAY_NAME is not rellay needed, but if SAS
can give me the holiday, that is nice, too.
10 Great Gift Ideas- Take a Look!