Dear All,


I would like kindly to generate two new variables from the following data. The first variable is a dummy equals to whenever "exclude" is equals to 1 in December of any year using "datadate". The second variable that I would like to generate is a dummy variable equals to 1 whenever exclude equals 1 on any the last quarter of the year "either October or Nov. or Dec.).


Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str6 gvkey long datadate double exclude float fyear
"001004" 15856 1 2003
"001004" 15948 0 2003
"001004" 16130 0 2004
"001004" 16222 0 2004
"001004" 16314 0 2004
"001004" 16587 0 2005
"001004" 16679 0 2005
"001004" 16770 0 2005
"001004" 16952 0 2006
"001004" 17135 0 2006
"001004" 17317 0 2007
"001004" 17409 0 2007
"001004" 17591 0 2008
"001004" 17956 0 2009
"001004" 18048 0 2009
"001004" 18140 0 2009
"001004" 18231 0 2009
"001004" 18321 0 2010
"001004" 18413 0 2010
"001004" 18505 0 2010
"001004" 18596 0 2010
"001004" 18961 1 2011
"001004" 19052 0 2012
"001004" 19144 1 2012
"001004" 19236 0 2012
"001004" 19327 0 2012
"001013" 15736 1 2003
"001013" 15825 1 2003
"001013" 15917 1 2003
"001013" 16009 1 2003
"001013" 16101 0 2004
"001013" 16832 1 2006
"001013" 17378 0 2007
"001013" 17652 1 2008
"001013" 17928 1 2009
"001013" 18443 1 2010
"001034" 15795 1 2003
"001034" 15886 1 2003
"001034" 16070 0 2003
"001034" 16161 1 2004
"001034" 16252 1 2004
"001034" 16344 0 2004
"001034" 16436 1 2004
"001034" 16526 1 2005
"001034" 16617 1 2005
"001034" 16709 0 2005
"001034" 17074 0 2006
"001034" 17256 0 2007
"001034" 17347 0 2007
"001034" 17439 0 2007
"001034" 17531 1 2007
"001034" 17805 1 2008
"001045" 15795 0 2003
"001045" 15886 1 2003
"001045" 15978 1 2003
"001045" 16070 1 2003
"001045" 16161 0 2004
"001045" 16252 1 2004
"001045" 16344 0 2004
"001045" 16436 0 2004
"001045" 16526 1 2005
"001045" 16617 0 2005
"001045" 16709 1 2005
"001045" 16801 1 2005
"001045" 16891 0 2006
"001045" 16982 0 2006
"001045" 17074 1 2006
"001045" 17166 1 2006
"001045" 17256 0 2007
"001045" 17347 0 2007
"001045" 17439 1 2007
"001045" 17531 1 2007
"001045" 17622 0 2008
"001045" 17713 1 2008
"001045" 17805 1 2008
"001045" 17897 1 2008
"001045" 17987 1 2009
"001045" 18078 1 2009
"001045" 18170 1 2009
"001045" 18262 1 2009
"001045" 18352 1 2010
"001045" 18443 0 2010
"001045" 18535 0 2010
"001045" 18627 1 2010
"001045" 18717 1 2011
"001045" 18808 0 2011
"001045" 18900 0 2011
"001050" 17074 0 2006
"001050" 17166 0 2006
"001050" 17256 0 2007
"001050" 17439 0 2007
"001050" 17531 0 2007
"001050" 17622 0 2008
"001050" 17713 0 2008
"001050" 17805 0 2008
"001050" 17897 0 2008
"001050" 17987 0 2009
"001050" 18078 0 2009
"001050" 18170 0 2009
"001050" 18352 0 2010
end
format %d datadate

Thanks a lot,