Hello statalisters
I have a datasheet containing the following information (example)
A B C D E F
1 2 3 4 5 6
2 8 5 4 9 6
3 5 7 8 6 1
7 4 5 6 8 1
2 4 6 4 1 6
I need a command that will tell me what the highest number in column E is
(in this example 9) and also return the value in column B for the same row
(i.e. in this example 8).
Thanks for your help,
Christopher D Fergusson
*
* 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/