DATA Step, Macro, Functions and more

return column name for second largest value in an array

Reply
Occasional Contributor
Posts: 11

return column name for second largest value in an array

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;

Super Contributor
Posts: 298

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

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.

Occasional Contributor
Posts: 11

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

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

Super Contributor
Posts: 298

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

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

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

Ask a Question
Discussion stats
  • 3 replies
  • 271 views
  • 0 likes
  • 2 in conversation