Date:         Fri, 29 Dec 2006 12:20:24 -0800
Reply-To:     "Sierra Information Services (Andrew Karp)" <sfbay0001@AOL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Sierra Information Services (Andrew Karp)" <sfbay0001@AOL.COM>
Organization: http://groups.google.com
Subject:      Re: Comparison across columns??
Comments: To: sas-l@uga.edu
In-Reply-To:  <200612291917.kBTIVA50023846@mailgw.cc.uga.edu>
Content-Type: text/plain; charset="utf-8"

I am certain someone else on the list will come up with a more elegant
and elaborate solution to your question, but in the meantime, allow me
to suggest that you look in to the MAX and MIN SAS Programming Language
Functions.

Andrew Karp
Sierra Information Services
www.SierraInformation.com


On Dec 29, 11:17 am, margaretasm...@HOTMAIL.CO.UK (Margaret Asmani)
wrote:
> Hi,
>
> I have 20 columns (variables) and want to compare their values.
> For example,
>
> A  B  C  D  E
> 25 32 65 32 89
> 65 32 47 89 96
> 41 52 63 96 45
> 12 45 65 98 78
> 45 56 89 78 63
> 45 89 56 89 56
> 56 89 56 45 78
> 45 56 56 78 89
> 12 45 98 65 78
> 12 12 32 35 56
>
> and want to compare the values i.e 25,32,65,32,89 and at the end be able to
> tell how many times variable A had the lowest value, which variable had the
> next higher value, the next higher value etc.
>
> Any suggestions?