<>
***
bysort GROUP: egen HISTATUS, max(STATUS)
***
best, rich
[email protected] 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/
