YES! That is what I want! man, you are a genius ! ... View more

Thanks! I understand. But there is more to the question when more than 1 row is missing consecutively: (and number of missing rows is indefinite) n  A  Name             C (intended answer)           C(currently achieved using either method) 1   1  Abbie            Abbie                                     Abbie 2   .    Bob              Abbie                                     Abbie 3   .    Charlie         Abbie                                     . 4   1   David           David                                     David 5   .    Eddie           David                                     David 6   .    Frank           David                                     . 7   .    George        David                                     . If I kept running SAS code your suggested manually, it will work out "eventually" (3 David -> 4 David -> etc...), but that won't be a solution. Many many thanks ! ... View more