topic Re: return column name for second largest value in an array in SAS Programming

return column name for second largest value in an array

ConsAth — Fri, 16 Sep 2016 15:02:30 GMT

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;

Re: return column name for second largest value in an array

KachiM — Fri, 16 Sep 2016 15:21:33 GMT

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.

Re: return column name for second largest value in an array

ConsAth — Fri, 16 Sep 2016 15:27:29 GMT

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

Re: return column name for second largest value in an array

KachiM — Fri, 16 Sep 2016 16:44:55 GMT

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

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