---------------------------- Forwarded with Changes --------------------------- From: SMTP:alakshm@TIGER.LSU.EDU at Internet Date: 4/30/98 12:55PM To: A. (Allan) Barless at EMPO0008 *To: SMTP:SAS-L@UGA.CC.UGA.EDU at Internet Subject: sorting question ------------------------------------------------------------------------ -------

Aruna Take a look at the 'ordinal' function in the sas manual. I think you want either one of the following: ordinal(3,of var1-var12) or ordinal(9,of var1-var12)

______________________________ Forward Header __________________________________ Subject: sorting question Author: SMTP:alakshm@TIGER.LSU.EDU at Internet Date: 30/04/98 12:55 PM

Hi, I have a problem. I have data with thousands of observations, and 12 variables. For each observation, I want to get the third highest values among these variables. Some variables may take the same values for an obeservation. For example, for obs 1, suppose, v1=.5 v2=.7 v3=.7 v4=.3 v5=.005 v6=.324 ( I am using 6 vars here), I want the third highest value which is .324. How do I do this?

Thanks, Aruna