I have a data set of patients and diagnosis codes, for example name, code Sarah, A1 Sarah, B1 Sarah, C1 Matt, A2 Matt, E2 Dave, A2 Dave, B3 Dave, E2 George, C2 George, A1 I am screening the patients for a research study. They all have A1 or A2. If they also have a B code or C code, they are not eligible for the study. I want to create a set like the following that just has 1 entry for each patient with a new variable that says if they are eligible and the code variable should be their A code. name, code, eligible Sarah, A1, no Matt, A2, yes Dave, A2, no George, A1, no How can I look at each code and then create one observation with a new variable to say if the patient is eligible?
... View more