topic Re: dataset of weekend and holiday dates in SAS Programming

dataset of weekend and holiday dates

Elliott — Tue, 04 Dec 2018 18:31:25 GMT

I am trying to create a data set with a list of all the weekend and US holiday dates like the example below, that will be for the entire 2019 year.

Is there an easy way to do that using SAS. This calendar dataset is utilized in my production code but the group that created it seems to no longer be around so I don't think they will be creating a 2019 version. This dataset is used as exclusion criteria in my code.

Thanks

HolidayName	Year	Holiday_Date
New Year's Day	2018	Monday, January 01, 2018
Weekends	2018	Saturday, January 06, 2018
Weekends	2018	Sunday, January 07, 2018
Weekends	2018	Saturday, January 13, 2018
Weekends	2018	Sunday, January 14, 2018
Martin Luther King Day	2018	Monday, January 15, 2018
Weekends	2018	Saturday, January 20, 2018
Weekends	2018	Sunday, January 21, 2018

Re: dataset of weekend and holiday dates

r_behata — Tue, 04 Dec 2018 18:42:18 GMT

Have you tried using the sas holiday function ?

http://www.sascommunity.org/wiki/Tips:Use_the_HOLIDAY_Function_to_Compute_the_Date_of_a_US_or_Canadian_Holiday

Re: dataset of weekend and holiday dates

ballardw — Tue, 04 Dec 2018 20:10:53 GMT

And: Weekend= WEEKDAY (somedatevalue) in (1,7);

https://communities.sas.com/t5/SAS-Communities-Library/Working-with-Dates-and-Times-in-SAS-Tutorial/ta-p/424354 has a PDF with much information about dates.

So a data set created something like should get you started.

Data datelist;

do date = '01JAN2019'd to '31Dec2019'd;
   HolidayName='Weekend';
   if weekday(date) in (1,7) then output;
end;
HolidayName='Christmas'; date= holiday('Christmas',2019); output;
format date date9.;
run;

Make sure to set a length for Holidayname long enough to hold the longest text as the above will set it to 7 characters which won't hold Christmas