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]

From |
Ronnie Babigumira <rb.glists@gmail.com> |

To |
statalist@hsphsun2.harvard.edu |

Subject |
Re: st: display identifiers accounting for duplicate obs |

Date |
Fri, 4 May 2012 22:33:04 +0200 |

sorry that should have been egen rhits = rank(-hits) -- 010100100110111101101110011011100110100101100101 On Friday, May 4, 2012 at 10:32 PM, Ronnie Babigumira wrote: > egen rhits = rank(hits)? > > > -- > 010100100110111101101110011011100110100101100101 > > > > > On Friday, May 4, 2012 at 10:27 PM, tashi lama wrote: > > > > > Hello all, > > > > I can't come up with this solution despite spending quite some thought and time. The problem in hand sounds fairly straigh forward > > > > > > I have a dataset like following > > > > > > hits > > > > 1 > > > > 2 > > > > 3 > > > > 4 > > > > 4 > > > > 5 > > > > 6 > > > > 6 > > > > > > and I want to generate variable rank. Notice, if there were no duplicate obs, i would have said > > > > > > gsort -hits > > > > gen rank=_n and rank column would have given the ranks of the obs. That is what i want. > > > > > > However, there are some duplicate obs and i tried doing > > > > gsort -hits > > > > gen rank=cond(hits[_n-1]==hits[_n], _n-1, _n) which would give me > > > > > > hits rank > > > > 6 1 > > > > 6 1 > > > > 5 3 > > > > 4 4 > > > > 4 4 > > > > 3 6 > > > > 2 7 > > > > 1 8 and that is not what I want. > > > > > > > > I looked at commands like generate, duplicates and I didn't see much relevant to my problem. > > > > > > > > Could someone give me a lead where to look at or which command should I dig in ? Thanks a lot. > > > > > > Tashi > > > > * > > * 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/ > * * 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/

**Follow-Ups**:**Re: st: display identifiers accounting for duplicate obs***From:*Nick Cox <njcoxstata@gmail.com>

**References**:**st: display identifiers accounting for duplicate obs***From:*tashi lama <ltashi32@hotmail.com>

**Re: st: display identifiers accounting for duplicate obs***From:*Ronnie Babigumira <rb.glists@gmail.com>

- Prev by Date:
**Re: st: display identifiers accounting for duplicate obs** - Next by Date:
**Re: st: display identifiers accounting for duplicate obs** - Previous by thread:
**Re: st: display identifiers accounting for duplicate obs** - Next by thread:
**Re: st: display identifiers accounting for duplicate obs** - Index(es):