Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: logic for changing values for grouped variables


From   Richard Ochmann <rochmann@diw.de>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: logic for changing values for grouped variables
Date   Mon, 28 Sep 2009 11:34:14 +0200

<>
***
bysort GROUP: egen HISTATUS, max(STATUS)
***

best, rich

owner-statalist@hsphsun2.harvard.edu schrieb am 22.09.2009 19:54:42:

> Hello.  I am battling the logic demons.  There has got to be a way 
> to do this using -egen- I think...
> 
> Let's say I have observations partitioned into groups.  Each 
> observation has a numeric value for STATUS, something like this...
> 
> GROUP             STATUS
> 1                 1
> 1                 1
> 1                 3
> 2                 3
> 3                 1
> 3                 2
> 3                 2 
> 
> I would like to create a third variable, HISTATUS, that takes the 
> highest value for STATUS within each group, and assigns it to every 
> observation within that group.  In the example above, HISTATUS would
> take on the value of 3 for all obs in GROUP 1, 3 for the obs in 
> GROUP 2, and 2 for all the obs in GROUP 3.
> 
> Can someone please suggest a clever way of doing that?  I am 
> guessing that it would involve -egen- and the rank option, but I 
> could be wrong about that.
> 
> Thank you for your help.  Lloyd Dumont
> 
> 
> 
> 
> 
> 
> 
> 
> *
> *   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–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index