Hi all, I want to backfill the ExecID data if BECAMECEO<=fyear<=LEFTOFC. Take year 1979 as an example, the EXECID should be the EXECID in 1994 because 1979 is within the executive employment period. year in ExecuComp Date became CEO date left CEO name EXECID 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 01Jan1955 01OCT1996 Ira A. Eichner 9248 1995 01Jan1955 01OCT1996 Ira A. Eichner 9249 1996 09OCT1996 31MAY2018 David P. Storch 9249 How can I code this to backfill the data?
... View more