Re: st: Looping within a subset under a certain condition

[Nick Cox <njcoxstata@gmail.com>]

With the simplified rule you announce at the end here, I believe that
my code is a complete solution. No looping is needed at all.

Nick

On Sun, Sep 30, 2012 at 10:10 AM, Gerard Solbrig
<gsolbrig@mail.uni-mannheim.de> wrote:
> Pengpeng, thanks for the reply.
>
> What you pointed out is somewhat of a special case I included in the
> example.
>
> For my understanding, as Stata works its way through all observations in
> every group of 'firm_id' and encounters a rep = 1 case, it'll just check on
> whether all other observations in that group (starting with the next
> observation, `i'+1) have a 'trandate' within the the range 'wind_start' and
> 'wind_end'.
>
> Thus, if it encounters another rep = 1 case (which are generally missing a
> 'trandate'), it should set 'rep_ins' = 0 for that case and continue to go
> through all other observations. I try to correct that by including the line
> 'replace rep_ins = . if rep == 1' after my loop.
>
> As for the possibility that there are multiple rep = 1 cases for one firm:
> ideally, the loop would indicate for each rep = 0 case within which of these
> different and possibly overlapping windows the observation's 'trandate'
> lies. But I assume that would add a whole lot more complications to the
> code. So for now, I'm just trying to get it to work so that it set's rep_ins
> = 1 if any observation's 'trandate' lies within the range 'wind_start'
> 'wind_end' of one or more rep = 1 cases for that firm.
>
> Best,
> Gerard
>
>
> -----Original Message-----
> From: owner-statalist@hsphsun2.harvard.edu
> [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of ???
> Sent: Sonntag, 30. September 2012 05:23
> To: statalist@hsphsun2.harvard.edu
> Subject: Re:st: Looping within a subset under a certain condition
>
> Hi Gerard,
>
> I thought your problem might be very similar as what I encountered before.
>
> You said that you attempted to indicate whether the date of all other
> observations of this firm (where rep = 0) lay within the range determined by
> 'wind_start' and 'wind_end', but in your data, the firm2 had two set of
> 'wind_start' and 'wind_end', (03jul1999 - 27jul2000 and 09jul1999 -
> 02aug2000), so which one should be used in the determination?
>
> Thank you.
> Best wishes,
>
> Pengpeng
> At 2012-09-29 04:45:06,"Gerard Solbrig" <gsolbrig@mail.uni-mannheim.de>
> wrote:
>>Dear Statalist-Members,
>>
>>I'm encountering a problem for which I seek your help.
>>
>>Let me start off with an example from my data (what I want it to look
>>like in the end), before I explain my particular problem.
>>
>>firm_id        date            rep     wind_start              wind_end
>>rep_ins
>>
>>firm1          01jan2000       0       .                       .
>>0
>>firm1          05apr2004       0       .                       .
>>1
>>firm1          01nov2004       1       05may2004               30may2005
>>.
>>firm1          10dec2004       0       .                       .
>>1
>>firm1          01jan2006       0       .                       .
>>0
>>firm2          30dec1999       1       03jul1999               27jul2000
>>.
>>firm2          05jan2000       1       09jul1999               02aug2000
>>.
>>firm2          06jun2000       0       .                       .
>>1
>>
>>Each firm in my data has a 'firm_id'. Variable 'date' refers to an
>>event date. The 'rep' dummy indicates the type of event.
>>I set 'wind_start' and 'wind_end' as period around the event
>>(-180days,+210days), in case it's a rep = 1 type event.
>>
>>Now, I would like the 'rep_ins' dummy to indicate (i.e., rep_ins = 1),
>>whether the date of all other observations of this firm (where rep = 0)
>>lies within the range determined by 'wind_start' and 'wind_end' (which
>>is conditional upon the 'rep' dummy).
>>
>>I've come across looping over observations and tried to design a
>>solution for this problem based on that, but failed to do so. I assume
>>the solution also depends on sorting the data in a special way.
>>
>>Here's the first part of my .do-file:
>>
>>gen wind_start = date-180 if rep == 1
>>gen wind_end = date+210 if rep == 1
>>format wind_start %d
>>format wind_end %d
>>gsort +cusip6 +date +trandate
>>gen rep_ins = 0 if rep != 1
>>
>>I tried to come up with a solution by adding variables 'per_start' and
>>'per_end' for all rep = 0:
>>
>>gen per_start = date-180 if rep == 0
>>gen per_end = date+180 if rep == 0
>>format per_start %d
>>format per_end %d
>>
>>To mark the period within which the rep = 1 event can lie. Maybe this
>>could contribute to finding a solution as well.
>>
>>All input is welcome. Thanks in advance.
>>Best,
>>Gerard Solbrig
>>
>>*
>>*   For searches and help try:
>>*   http://www.stata.com/help.cgi?search
>>*   http://www.stata.com/support/faqs/resources/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/faqs/resources/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/faqs/resources/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/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/