st: Re: How Can I Create the Variable x?

["Michael Blasnik" <michael.blasnik@verizon.net>]

I think this does what you want:

bysort id (bsid): gen x=sum(bsid!=bsid[_n-1])

Michael Blasnik

----- Original Message ----- 
From: "Raphael Fraser" <raphael.fraser@gmail.com>
To: <statalist@hsphsun2.harvard.edu>
Sent: Sunday, January 28, 2007 9:12 PM
Subject: st: How Can I Create the Variable x?



> I need help in creating the var x.
>
> id bsid  x
> 1  22    1
> 1  22    1
> 1  52    2
> 1  87    3
> 2  43    1
> 2  43    1
> 2  11    2
> 3  28    1
> 4  33    1
>
> I have tried,
> bysort id bsid: gen x = _n
> bysort id (bsid): gen x = _n
*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/