Goodmorning,

For my thesis it is very important to remove all firms in my compustat database for which the fiscal year-end changes(to ensure the comparability of different years)
I have no idea which command to use to reach this. Can someone help me with this?

For example:
GVKEY: 00104 Datadate: 31may2009 Fyear: 2008
GVKEY 00104 Datadate: 31may 2010 Fyear: 2009
GVKEY 00104 Datadte: 31June 2011: Fyear: 2010
When this is the case the firm with GVKEY 00104 must be removed from my database, because of the change in Datadate.

I hope someone can help me!

Kind regards,
Sjoerd