Hi Ksharp Thank you for quick respond. I'm not sure how to make my own intervals. I found this example for custom intervals to omit holidays when counting business days in the function INTCK: I don't know how to adjust this to my holiday list. options intervalds=(BankingDays=BankDayDS); data BankDayDS(keep=BEGIN); start = '15DEC1998'D; stop = '15JAN2002'D; nwkdays = INTCK('WEEKDAY',start,stop); do i = 0 to nwkdays; BEGIN = INTNX('WEEKDAY',start,i); year = YEAR(BEGIN); if BEGIN ne HOLIDAY("NEWYEAR",year) and BEGIN ne HOLIDAY("MLK",year) and BEGIN ne HOLIDAY("USPRESIDENTS",year) and BEGIN ne HOLIDAY("MEMORIAL",year) and BEGIN ne HOLIDAY("USINDEPENDENCE",year) and BEGIN ne HOLIDAY("LABOR",year) and BEGIN ne HOLIDAY("COLUMBUS",year) and BEGIN ne HOLIDAY("VETERANS",year) and BEGIN ne HOLIDAY("THANKSGIVING",year) and BEGIN ne HOLIDAY("CHRISTMAS",year) then output; end; format BEGIN DATE.; run; Bob
... View more
