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: Data Management question
From
Hitesh Chandwani <[email protected]>
To
[email protected]
Subject
Re: st: Data Management question
Date
Tue, 25 Jun 2013 13:48:06 -0500
Thanks so much Nick! Worked like a charm.
On Tue, Jun 25, 2013 at 12:02 PM, Nick Cox <[email protected]> wrote:
> You said
>
> "I could do this the long way with repeated gen and replace commands".
>
> Actually that sounds a nightmare without some small tricks. Here are mine:
>
> egen ABCDE = concat(A B C D E)
>
> For consecutive 1s, the trick is only that somewhere in the string
> concatenation we will find "111" or "11".
>
> gen X = strpos(ABCDE, "111") > 0
> gen Y = strpos(ABCDE, "11") > 0
>
> Your third definition splits into two
>
> For one non-consecutive 1, the condition "non-consecutive" is superfluous.
>
> For two non-consecutive 1s, there are in total two 1s and they must
> not be consecutive. The variable -Y- already codes two consecutive
> 1s.
>
> Either way, try
>
> gen Z = inlist(A + B + C + D + E, 1, 2) & !Y
>
> Nick
> [email protected]
>
> On 25 June 2013 17:46, Hitesh Chandwani <[email protected]> wrote:
>
>> I have a data management issue. I need to generate a couple of
>> indicator variables from variables that already exist in the dataset.
>>
>> Let's call the required indicator vars X, Y, and Z with values of 1 or
>> 0. Whether the value of these vars is 1 or 0 depends on the value of 5
>> other indicator variables (A, B, C, D, E). A-E are chronologically
>> ordered (i.e., A indicates an event that happened before B, which
>> happened before C, and so on).
>>
>> For each observation:
>> X = 1 if at least 3 "consecutive" vars from A-E are equal to 1.
>> Y = 1 if at least 2 "consecutive" vars from A-E are equal to 1.
>> Z = 1 if only 1 or 2 "non-consecutive" vars from A-E are equal to 1.
>>
>> I could do this the long way with repeated gen and replace commands
>> but I'm sure there's a better way to do it (only I don't know how).
> *
> * 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/
--
Hitesh S. Chandwani
University of Texas at Austin
*
* 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/