I would like to check where a number is located in a multi-dimensional array. Then, I would like to take the minimum of the entire column for that particular row. For example, I have the following data sets. This is a 3-dminesional with 3 rows and 5 columns. array temp{3,5} a1_1-a1_5 a2_1-a2_5 a3_1-a3_5; In the first observation, Check1= 111 is located at temp{2,3}. For non-missing values, I would like to take the minimum. So, min(a2_1-a2_5)=1. In the second observation, Check1=222 is located at temp{2,4} and min(a2_1-a2_5)=1. Check2=223 is located at temp{3,2} and min(a3_1-a3_5)=3. data k; input check1 check2 a1_1 -a1_5 a2_1-a2_5 a3_1-a3_5; datalines; 111 . 12 122 133 . . 1 11 111 13 . 777 2 . . . 222 223 5 555 232 . . 1 111 123 222 224 11 223 3 . . ; run; Thank you
... View more