RE: st: Column and row maximums

 From Chris.Fergusson@sth.nhs.uk To statalist@hsphsun2.harvard.edu Subject RE: st: Column and row maximums Date Tue, 19 Nov 2002 14:25:34 -0000

```Sorry if I was ambiguous; from the datasheet

> 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 would simply like Stata to return something of the sort:

"Highest value in E was" 9 "and the corresponding value in B was" 8

> -----Original Message-----
> From:	Stephen P. Jenkins [SMTP:stephenj@essex.ac.uk]
> Sent:	Tuesday, November 19, 2002 2:24 PM
> To:	statalist@hsphsun2.harvard.edu
> Subject:	Re: st: Column and row maximums
>
> On Tue, 19 Nov 2002 14:02:02 -0000 Chris.Fergusson@sth.nhs.uk wrote:
>
> > 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).
>
>
> . ge id = _n
>
> . l
>
>             a         b         c         d         e         f         id
>   1.        1         2         3         4         5         6          1
>   2.        2         8         5         4         9         6          2
>   3.        3         5         7         8         6         1          3
>   4.        7         4         5         6         8         1          4
>   5.        2         4         6         4         1         6          5
>
> . sort e
>
> . replace b = e if _n==_N
>
> . l
>
>             a         b         c         d         e         f         id
>   1.        2         4         6         4         1         6          5
>   2.        1         2         3         4         5         6          1
>   3.        3         5         7         8         6         1          3
>   4.        7         4         5         6         8         1          4
>   5.        2         9         5         4         9         6          2
>
> . sort id
>
> . list
>
>             a         b         c         d         e         f         id
>   1.        1         2         3         4         5         6          1
>   2.        2         9         5         4         9         6          2
>   3.        3         5         7         8         6         1          3
>   4.        7         4         5         6         8         1          4
>   5.        2         4         6         4         1         6          5
>
> Or have I misunderstood what you were trying to accomplish? (And how do
> you want to treat repeated values for a maximum?)
>
> Stephen
> ----------------------
> Professor Stephen P. Jenkins <stephenj@essex.ac.uk>
> Institute for Social and Economic Research (ISER)
> University of Essex, Colchester, CO4 3SQ, UK
> Tel: +44 (0)1206 873374. Fax: +44 (0)1206 873151.
> http://www.iser.essex.ac.uk
>
> *
> *   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/
*
*   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/
```