Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | njcoxstata@gmail.com |
To | "statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu> |
Subject | Re: st: Identifying switchers in panel data |
Date | Wed, 11 Sep 2013 17:37:24 +0100 |
Are you classifying one-step changes or households? -tsspell- is from SSC. Nick njcoxstata@gmail.com On 11 Sep 2013, at 14:54, Dana Shills <shills52@hotmail.com> wrote: > I am using an unbalanced panel dataset of 100,000 households which a status variables that takes values 0,1,2. Some households never switch status and some toggle between the three states. How do I identify how many switchers there are between each of these categories (0,1) (1,0) (0,2) (2,0) (1,2) (2,1). I have been trying to work with -tsspell - but it doesn't quite get me what I need. > > Here is a sample of the data. > > ID time status > 1 0 1 > 1 1 1 > 1 2 1 > 1 3 1 > 2 0 0 > 2 1 2 > 2 2 1 > 2 3 0 > 2 4 0 > 3 0 2 > 3 1 1 > 4 0 0 > 4 1 1 > 4 2 1 > > * * 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/