st: Identifying switchers in panel data

[Dana Shills <shills52@hotmail.com>]

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

Thanks

Dana 		 	   		  
*
*   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/