I have a dataset looks as the following: Name Score A 766 A 9 A 93 A 869 A 143 B 8 B 119 B 362 B 6 B 95 C 524 C 99 C 123 C 176 C 210 D 8 D 0 D 31 D 123 D 12 I need to set the score value to do the following: 1. if the score value less than 10, set the score to missing 2. if there is only one score less than 10 for each name group, then set the second minimum score to missing. (that's where I am stuck. ) for example, the above table: for Name A, 9 and 93 should set to missing; for Name B, 8 and 6 should set to missing ... BTW, the number of each name is always 5.
... View more