Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: RE: Duplicates order tagging
From
Nick Cox <[email protected]>
To
[email protected]
Subject
Re: st: RE: Duplicates order tagging
Date
Fri, 28 Oct 2011 08:21:52 +0100
See also for related tricks
FAQ . . . . . . . . . . . . . . . . . . . . . . Creating group identifiers
. . . . . . . . . . . . . . . . . . . . . . . . N. J. Cox and W. Gould
3/01 How do I create individual identifiers numbered
from 1 upwards?
http://www.stata.com/support/faqs/data/group.html
On Fri, Oct 28, 2011 at 7:34 AM, Jesper Lindhardsen
<[email protected]> wrote:
> Try
>
> bysort letter: gen order = _n
>
Ben Hoen
> If I have a set that contains the following values:
>
> letter
> 1. A
> 2. A
> 3. A
> 4. B
> 5. B
> 6. C
>
> I can use .duplicates tag, g(freq) to generate a count of the
> duplicates:
>
> letter freq
> 1. A 3
> 2. A 3
> 3. A 3
> 4. B 2
> 5. B 2
> 6. C 1
>
> But I would also like to generate an order variable (e.g., " order")
> that
> increases for each successive iteration of the variable. Such as:
>
> letter freq order
> 1. A 3 1
> 2. A 3 2
> 3. A 3 3
> 4. B 2 1
> 5. B 2 2
> 6. C 1 1
>
> Is there an easy way to do that?
*
* 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/