Bookmark and Share

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: display identifiers accounting for duplicate obs


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/


© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index