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
In-Reply-To:  <20071212232133.E5F2A1CE882@ws1-6.us4.outblaze.com>
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?

-----Original Message-----
From: Tom White [mailto:snip]
Sent: Wednesday, December 12, 2007 3:22 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: How to etermine if date is a holiday

Hello SAS-L,

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                .

etc.

You get the idea.

I think the major holidays we have are:
New Years Day
Memorial Day
Independence Day
Labor Day
Thanksgiving Day
Christmas 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.

Thank you.

TOM

--
10 Great Gift Ideas- Take a Look!
http://mail.shopping.com/?linkin_id=8033174