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;
... View more