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;
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.
thank you for the input but this doesnt resolve my query of having the column name of each value returned
L2 = largest(2, of array[*]);
pos = whichN(L2, of array[*]);
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.