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;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.