I have 30 numeric variables (named VALUE1, VALUE2, VALUE3, …) and have already written to code to find which has the Maximum value, however, I also need to know which of the 30 numeric variables produced that maximum value. Please see the example code below (this is what I have so far, but I don't know what else I need to get my desired output). data example1; set example; MAX_Value= max( VALUE1, VALUE2, VALUE3, …, VALUE29, VALUE30); run; Basically I just need to know for a given observation if the maximum value is 1000 which of the 30 values did that come from.
... View more