this has promise. I think my whole issue is my dates are not the right format. if you look on the log where i printed the companyholidays macro variable my dates look like
%put List of name: &companyHOLIDAYS.; List of name: 31DEC1999,01JAN2001,01JAN2002,01JAN2003,01JAN2004,31DEC2004,02JAN2006,01JAN2007,01JAN2008,01JA N2009,01JAN2010,31DEC2010,02JAN2012,01JAN2013,01JAN2014,01JAN2015,01JAN2016,02JAN2017,01JAN201 8,01JAN2019,01JAN2020,01JAN2021,31DEC2021,02JAN2023,01JAN2024,01JAN2025,01JAN2026,01JAN2027,31 DEC2027,01JAN2029,01JAN2030,01JAN2031,01JAN2032,31DEC2032,02JAN2034,01JAN2035,01JAN2036,01JAN2 037,01JAN2038,31DEC2038,02JAN2040,01JAN2041,01JAN2042,01JAN2043,01JAN2044,02JAN2045,01JAN2046, 01JAN2047,01JAN2048,01JAN2049,31DEC2049, 17JAN2000,15JAN2001,21JAN2002,20JAN2003,19JAN2004,17JAN2005,16JAN2006,15JAN2007,21JAN2008,19JA N2009,18JAN2010,17JAN2011,16JAN2012,21JAN2013,20JAN2014,19JAN2015,18JAN2016,16JAN2017,15JAN201 8,21JAN2019,20JAN2020,18JAN2021,17JAN2022,16JAN2023,15JAN2024,20JAN2025,19JAN2026,18JAN2027,17 JAN2028,15JAN2029,21JAN2030,20JAN2031,19JAN2032,17JAN2033,16JAN2034,15JAN2035,21JAN2036,19JAN2 037,18JAN2038,17JAN2039,16JAN2040,21JAN2041,20JAN2042,19JAN2043,18JAN2044,16JAN2045,15JAN2046, 21JAN2047,20JAN2048,18JAN2049,17JAN2050,
instead of
proc hpfevents;
eventdef SuperBowl = '15JAN1967'D '14JAN1968'D '12JAN1969'D '11JAN1970'D
'17JAN1971'D '16JAN1972'D '14JAN1973'D '13JAN1974'D '12JAN1975'D
'18JAN1976'D '09JAN1977'D '15JAN1978'D '21JAN1979'D '20JAN1980'D
'25JAN1981'D '24JAN1982'D '30JAN1983'D '22JAN1984'D '20JAN1985'D
'26JAN1986'D '25JAN1987'D '31JAN1988'D '22JAN1989'D '28JAN1990'D
'27JAN1991'D '26JAN1992'D '31JAN1993'D '30JAN1994'D '29JAN1995'D
'28JAN1996'D '26JAN1997'D '25JAN1998'D '31JAN1999'D '30JAN2000'D
'28JAN2001'D '03FEB2002'D '26JAN2003'D '01FEB2004'D '06FEB2005'D
'05FEB2006'D '04FEB2007'D '03FEB2008'D '01FEB2009'D '07FEB2010'D
'06FEB2011'D '05FEB2012'D '03FEB2013'D '02FEB2014'D '01FEB2015'D
'07FEB2016'D '05FEB2017'D '04FEB2018'D '03FEB2019'D '02FEB2020'D
'07FEB2021'D '06FEB2022'D '05FEB2023'D '04FEB2024'D '02FEB2025'D
/ PULSE=DAY ;
eventdata out=superbowl condense;
eventdata out=superbowl_full;
run;
title 'Results of HPFEVENTS - Condensed';
proc print data=superbowl;
run;
... View more