Hi All, This time I am more descriptive for what I need. I created some of the numbers using the data step and numbers are as follows data test; input a b c d; cards; 10 9 13 10 7 7 9 8 6 7 6 8 2 3 3 4 3 4 6 6 6 7 6 7 8 7 7 7 9 8 11 10 9 9 9 9 ; run; I would like to acheive below information Case a b c d Flag_a Flag_b Flag_c Flag d Count Final_number 1 10 9 13 10 10 9 13 . 3 10 2 7 7 9 8 7 . 9 8 3 8 3 6 7 6 8 6 7 . 8 3 7 4 6 7 6 7 6 7 . . 4 7 5 9 8 11 10 9 8 11 10 4 9 6 2 3 3 4 2 3 . 4 3 3 7 3 4 6 6 3 4 6 . 4 4 8 8 7 7 7 8 7 . . 4 8 9 9 9 9 9 9 . . . 4 9 Case:1 Any number repeat assgin missing value to the next repeated variable like Flag_d is missing and count column should be 3 because only one missing and in the final_number column I need 10 because minimum of middle two number . e.g 9,10,10,13 middle two number 10 is the minimum numer Case2: Similar as above example Case 3:repeated number assign missing value in respective flag variable following the flag_a and count 3 as there are only one missing values in the flag variables and final number is 7 Case 4: there are two missing values in the flag variables such as flag_c and flag_d therefore count is set to 4 and final_number is 7 Case5: there are no repeated numbers means no missing flag count 4 and get the final_number is 3
... View more