Actually, this will give the Maximum Value; (By the way, is there a way to write this more easy->MAX(Limit_Rand1,Limit_Rand2,Limit_Rand3) PROC SQL;
Create Table Want2 As
SELECT *, MAX(limit_Rand1,limit_rand2,limit_rand3) As MaxVal From Want;
QUIT; But I want to pull the limit value , which is eqaul to number of Rand variable, I mean, if limit_Rand_03 greater than limit_Rand_01 and limit_Rand_02 then, it should bring Limit_1's original value in a new column(MaxValue). if limit_Rand_02 greater than limit_Rand_01 and limit_Rand_03 then, it should bring Limit_2s original value in a new column(MaxValue). if limit_Rand_03 greater than limit_Rand_02 and limit_Rand_03 then, it should bring Limit_3s original value in a new column(MaxValue). Thank you
... View more