Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: Pulling out observations based on a condition


From   Dmitriy Krichevskiy <krichevskyd@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Pulling out observations based on a condition
Date   Wed, 29 Jul 2009 11:55:47 -0400

Thanks a lot Jeph,
First, to clarify - I would like to keep those that do transition. But
I want to handpick those who transition from state 1 to state 5 - not
just those that leave state 1 to go anywhere. Thanks again, Dmitriy

2009/7/29, Jeph Herrin <junk@spandrel.net>:
>
> By "pull out", do you mean "drop" or "keep"? Here's a way
> to keep them. Let -id- identify individuals, -time-
> identify periods, and -status- be dichtomous variable of
> interest.
>
>   /* tag those who transition from period to period */
>   bys id (time) : gen transition=(status!=status[_n-1])|(_n==1)
>
>   /* check if individual always transitions */
>   bys id : egen alwaystransits=min(transition)
>
>   /* if they always transitioned, notrans==0 */
>   keep if alwaystransits
>
> This keeps those who transition between every time period.
>
> hth,
> Jeph
>
>
>
>
> Dmitriy Krichevskiy wrote:
>> Dear Statalisters,
>>
>> I have a panel data set with about 14000 people and 21 time periods. I
>> wanted to pull out persons who have transitioned from one category of
>> the same dichotomous variable to another (say from lowest income
>> quintile to the highest) during one time increment - for the whole
>> duration on the sample. So, essentially, I need to pull out all the
>> people that did that transition from first period to second plus from
>> second to third and so on... I know it is a simple loop but whatever I
>> do Stata drops all of the observations. Perhaps, I should also mention
>> that I am new to programing altogether. Thanks for all of your help,
>> Statalisters definitely  will be thanked in my dissertation.
> *
> *   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/
>


-- 
Dmitriy Krichevskiy a. b. c. d. e. f. g. h. i. j. k. l. m. n. o. p. q.
r. s. t. u. v. w. x. y. z.
*
*   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/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index