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;
data want;
array col(5) (1 3 5 10 4);
index_of_2nd=whichn(largest(2,of col(*)),of col(*));
value_1=vname(col(index_of_2nd));
run;
Use function LARGEST
You know how to do that as demonstrated in the code you posted. You just need to know how to find the second largest value.
data want;
array col(5) (1 3 5 10 4);
index_of_2nd=whichn(largest(2,of col(*)),of col(*));
value_1=vname(col(index_of_2nd));
run;
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.