Hi,
Im working with 10 variables and I want to generate a new variable that takes the average value of 1-3 (maximum) variable/s from the 10variables (condition on within the 10variables there are variable/s have a value greater than 0.1, if there are more than 3 variables have a value greater than 0.1 - select 3variables with the highest value then take the average )
All helps appreciated
Cheers,
Tom
Im working with 10 variables and I want to generate a new variable that takes the average value of 1-3 (maximum) variable/s from the 10variables (condition on within the 10variables there are variable/s have a value greater than 0.1, if there are more than 3 variables have a value greater than 0.1 - select 3variables with the highest value then take the average )
All helps appreciated
Cheers,
Tom
Comment