Dear all, I have a time series unbalanced dataset. I want to keep all data after the firm is identified as Seasoned Equity Offering (SEO) issuer and the one year before it. Then delete all years before the firm is an SEO issuer. Also, I want to mark all non-SEO issuers in the same data set. All I can do now is to identify the year in which the firm issues SEO. I am stuck on how to do the rest. A sample of the data and the desired column (SEO) is pasted below. In the file, when PROCEEDS has a number, that means the firm is an SEO. Anything after a positive PROCEEDS should be marked as SEO for the firm. GVKEY is firm id. One year before PROCEEDS is positive should also be marked as SEO. Two or more years before PROCEEDS is positive should be deleted for that particular firm. For firms who never have positive PROCEEDS, they should be marked as non-SEO or SEO=0. Thanks for any amount of help. Regards, Hinh GVKEY FYEAR PROCEEDS seo 001011 198 delete 001011 1984 delete 001011 1985 delete 001011 1986 delete 001011 1987 delete 001011 1988 delete 001011 1989 delete 001011 1990 delete 001011 1991 delete 001011 1992 11.3 1 001011 1993 1 001011 1994 37.5 1 001012 1979 1 001012 1980 1 001012 1981 1 001012 1982 1 001012 1983 1 001012 1984 1 001012 1985 1 001012 1986 1 001012 1987 1 001012 1988 1 001012 1989 1 001013 1979 0 001013 1980 0 001013 1981 0
... View more