Hi, the situation is little bit complicated, so the title might not describe it well. I have two dataset with same subjects, one dataset is cleaned with one row and one unique subject ID and group variables, like below: ID Group 1 Group 2 Group 3 1 1 0 0 2 0 1 0 3 0 0 1 4 0 0 1 and other one is not cleaned with multiple same IDs with a condition variable, like below: ID Condition 1 Long strings example 1 2 Short string example 2 3 Long strings example 1 3 Long strings example 1 3 Short strings example 2 4 Long strings example 1 4 Short strings example 2 Original condition contains really long strings so I used "long strings example 1" and "short string example 2" as examples. Generally, if the ID is in the group 1, this subject is "long strings example 1" only; if the ID in the group 2, this subject is "short strings example 2" only; if the ID in the group 3, this subject has both "long strings example 1" and "short strings example 2" several times. Here is what I want to do, I only want two groups: group 1 and group 2. Group 3 here just is used to mark this ID has both "long" and "short" several times(but I don't know how many times for each "long" and "short"). So if the ID has 2 or more "long strings example 1", I want to divide it into group 1. Here, because ID 3 has more than 2 "long"s, the ID 3 should be divided into group 1. And if ID has one "short strings example 2" and the "long strings example 1" is less than 2, then this ID is belongs to group 2. Here, because ID 4 has only 1 "long", and one "short", it belongs to group 2. So, I need to work on the two datasets together. Eventually, the dataset should look like belows: ID Group 1 Group 2 Group 3 Final group 1 1 0 0 1 2 0 1 0 0 3 0 0 1 1 4 0 0 1 0 In the final group, 1 is group 1, and 0 is group 2. Could anyone helps me with it? Hopefully, I made myself clearly. Thank you!
... View more