Hello!   Just wanted to see if there is a straight-forward way to do this without having a ton of if-then statements.  I have a dataset like this:   Observation 1: Var1 =S Var2 = D Var3 = S Var4 = <missing value>   Observation 2: Var1 =<missing value> Var2 = D Var3 = D Var4 = <missing value>   In my dataset there can be every combination of 'S', 'D' or empty values among the four variables.  What I need to do, row by row, is check if the populated variables are equal and ignore the variables that are empty .    I started writing code with if-then statements that checks if var1 ne '' and var2 eq '' and var3 eq '' and var4 eq ''....blah blah blah but I'm going to have to check for every possible combination of populated/empty vars and it's getting too long.    Is there an easier way to do this?    Thanks!  ... View more