creation of dummy 2

[amanjot_42]

Hi,

Thanks for the help!

I have noticed, there is another column of audit year which looks like below. I want to create a dummy, where year=audit_year.

Firm ID  Year    Audit_year        Dummy (what I want)
11      1990       .                   0
11      1991       .                   0 
11      1992   1993                    0
11      1993       .                   1
11      1994   1995                    0
11      1995       .                   1  
11      1996       .                   0
12      2001       .                   0
12      2002   2003                    0
12      2003      .                    1
12      2004      .                    0
12     2005       .                    0
12     2006       .                    0
12     2007       .                    0
12     2008       .                    0
12     2009       .                    0

In the latter table, audit years are one year ahead of YEAR. Please help with respect to the codes

Regards,
Amanjot

[PeterClemmensen]

So you want dummy=1 if Audit_Year is not missing in the previous obs?