Should be:
bysort GROUP: egen HISTATUS = max(STATUS)
or
egen HISTATUS = max(STATUS) by(GROUP)
Nick
[email protected]
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/
