Thank you, that worked. As a follow up, I'm wondering how to do something similar when there is missing data present. For example, starting with a similar data set, except I've added in some missings: var1 var2 var3 var4 var5 var6 var7 var8 . 1 7 . 3 5 6 9 4 6 . 15 . 2 10 0 15 22 6 . 2 98 1 . I'd like to end up with a similar results, except where the missing values are not included (relevant values colored for clarity): var1 var2 var3 var4 var5 var6 var7 var8 first last . 1 7 . 3 5 6 9 1 9 4 6 . 15 . 2 10 0 4 0 15 22 6 . 2 98 1 . 15 1 Thank you.
... View more