Re: st: display identifiers accounting for duplicate obs

[Ronnie Babigumira <rb.glists@gmail.com>]

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/