Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: Creating a dummy variable under certain conditions
From
Abhimanyu Arora <[email protected]>
To
[email protected]
Subject
Re: st: Creating a dummy variable under certain conditions
Date
Sat, 2 Jun 2012 15:01:08 +0200
Thanks Nick, yes.
But I would go for your solution which would be better in case he had
a longer lag.
On Sat, Jun 2, 2012 at 2:56 PM, Nick Cox <[email protected]> wrote:
> This looks OK as long as you substitute -viol- for -gvkey-. The
> previous values concerned are for -viol-, not -gvkey-.
>
> Nick
>
> On Sat, Jun 2, 2012 at 1:51 PM, Abhimanyu Arora
> <[email protected]> wrote:
>
>> Try this if your data is -xtset-ted
>> gen new_viol_dummy=L.gvkey+L2.gvkey+L3.gvkey+L4.gvkey==0
>
>> On Sat, Jun 2, 2012 at 2:06 PM, sebas nicaise <[email protected]>
>>
>>> I am struggeling with creating a new dummy variable. I have a very large
>>> (unbalanced) panel dataset that looks like this:
>>>
>>>
>>>
>>> date gvkey viol
>>> 1997q1 1021 0
>>> 1997q2 1021 0
>>> 1997q3 1021 0
>>> 1997q4 1021 0
>>> 1998q1 1021 1
>>> 1998q2 1021 0
>>> 1998q3 1021 0
>>> 1998q4 1021 1
>>> 1999q1 1021 0
>>>
>>> 1999q2 1021 0
>>>
>>> 1999q3 1021 0
>>> 1999q2 1023 0
>>> 1999q3 1023 1
>>> 1999q4 1023 0
>>> 2000q1 1023 0
>>> 2000q2 1023 1
>>>
>>>
>>> Where date is calender quarter, gvkey is the company identifier and viol a
>>> dummy which equals 1 if the firm is in violation of a covenant in a private
>>> debt contract.
>>>
>>>
>>>
>>> The problem is that I have to create a new dummy variable ( new violation)
>>> which meets certain conditions.
>>>
>>> The new violation dummy is only allowed to be 1 if in the previous 4
>>> quarters of a certain company (gvkey) is 0.
>>>
>>>
>>>
>>> This means for example that:
>>>
>>>
>>>
>>> date gvkey viol Newviolation
>>> 1997q1 1021 0 0
>>> 1997q2 1021 0 0
>>> 1997q3 1021 0 0
>>> 1997q4 1021 0 0
>>> 1998q1 1021 1 1
>>> 1998q2 1021 0 0
>>> 1998q3 1021 0 0
>>> 1998q4 1021 1 0
>>> 1999q1 1021 0 0
>>>
>>> 1999q2 1021 0 0
>>>
>>> 1999q3 1021 0 0
>>> 1999q2 1023 0 0
>>> 1999q3 1023 1 0
>>> 1999q4 1023 0 0
>>> 2000q1 1023 0 0
>>> 2000q2 1023 1 0
>>>
>>>
>>>
>>> I do not know how to tell Stata to create this variable, Hope someone is
>>> so kind to help me.
>
> *
> * For searches and help try:
> * http://www.stata.com/help.cgi?search
> * http://www.stata.com/support/statalist/faq
> * http://www.ats.ucla.edu/stat/stata/
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/