In addition to other suggestions, see
-rowsort- and -rowranks- on SSC.
Nick
[email protected]
israel solaresbravo
> i have the following problem:
>
> i want to construct a variable called margin of victory:
>
> my data set looks something like this:
>
>
> state votesA votesB votesC votesD
> 1 10 1 6 21
> 2 11 2 7 22
> 3 12 3 8 13
> 4 1 4 2 3
> 5 2 5 3 7
>
> my question is:
>
> how do i create a variable called margin_of_victory = votes
> for 1st place -
> votes for 2nd place?, i.e. 21-10 for state 1, 22 - 11 for
> state 2, 13 - 12
> for state 3, 4 - 3 for state 4, etc.
>
> i can't do this by hand, since i have a huge data set.
>
> i know that the command
>
> . egen margin_of_victory = rmax (votesforA votesforB
> votesforC votesforD)
>
> will help me pick the biggest number in each row, but how do
> i get to choose
> the 2nd biggest number?
>
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
