return column name for second largest value in an array

[ConsAth]

Hi all,

What i am trying to accomplish is the following , i have an array with 4 variables containing values lest say 1, 2 ,5, 6 etc.

I am able to get the max value of the array and have the column name returned but I am stuck on how I can do the same procedure for the next largest value, any ideas?

Kind regards and thank you in advance

This is my script up till now

DATA WANT;
SET HAVE;

ARRAY COL(*) col1 --col4;

INDEX_OF_MAX=WHICHN(MAX(OF COL(*)),OF COL(*));
VALUE_1=VNAME(COL(INDEX_OF_MAX));
RUN;

[KachiM]

There are LARGEST(x, ...) and SMALLEST(x, ..) functions available.

In LARGEST()

X = 1 stands for first largest

X = 2 stands for second larget and so on.

[ConsAth]

thank you for the input but this doesnt resolve my query of having the column name of each value returned

[KachiM]

L2 = largest(2, of array[*]);

pos = whichN(L2, of array[*]);