I have a dataset with 3 variables - V1, V2 and V3.
V1 V2 V3
1 1 A
2 A C
3 2 M
B D 3
I want to compare the variables and find if the values in varibale V1 is present in either of the variable V2 or V3 and generate the output accordingly.
So in the above example, 1, 2 and 3 values of variable V1 are present in either V2 or in V3 variables. Ouput should say "B" is not present in V2 and V3.
Any help would be greatly appreciated.
... View more