the below code creates ten years worth of trigger dates in a SAS bdat. Read that into Excel to control your work. Prof Bob data dval ( keep = dt take ) ;
dt = '30Apr2023'd ; format dt date9. ;
do k = 1 to 3660 ; * about ten years ;
dt = dt + 1 ; take = 0 ;
if ( day(dt) EQ 1 ) then
if ( month(dt) IN(1,4,7,10) ) then take = 1 ; ;
if ( ( day(dt) IN(8,9,10,11,12,13,14) ) AND
( weekday(dt) EQ 3 ) ) then take = 3 ;
if ( ( day(dt) IN(15,16,17,18,19,20,21)) AND
( weekday(dt) EQ 6 ) ) then take = 6 ;
if ( take ) then output ;
end ; * k loop ;
run ;
... View more
