RE: st: logic for changing values for grouped variables

 From "Nick Cox" To Subject RE: st: logic for changing values for grouped variables Date Mon, 28 Sep 2009 11:09:37 +0100

```Should be:

bysort GROUP: egen HISTATUS = max(STATUS)

or

egen HISTATUS = max(STATUS) by(GROUP)

Nick
n.j.cox@durham.ac.uk

Richard Ochmann

bysort GROUP: egen HISTATUS, max(STATUS)

Lloyd Dumont

> 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.
>

*
*   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/
```