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

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

Since he didn't actually state how x is defined (I almost hit the delete 
because of this omission), but did give examples sorting on id bsid, I 
assumed that his example had a small error in that 2 11 should be before 2 
43.  If he really wants the ordering of id bsid unchanged in its currently 
unsorted way , then this should work:

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

Michael

----- Original Message ----- 
From: "Nick Cox" <n.j.cox@durham.ac.uk>
To: <statalist@hsphsun2.harvard.edu>
Sent: Monday, January 29, 2007 6:55 AM
Subject: st: RE: Re: How Can I Create the Variable x?



> That doesn't match Raphael's example, as
>
> 2 43
>
> and
>
> 2 11
>
> would be categorised differently. The question
> is thus whether he minds.
>
> Nick
> n.j.cox@durham.ac.uk
>
> Michael Blasnik
>
> > I think this does what you want:
> >
> > bysort id (bsid): gen x=sum(bsid!=bsid[_n-1])
> Raphael Fraser
>
> > >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/