Hello I am not sure if someone could help me with the following: I have a longitudinal dataset of a binary variable that is equal to 1 when there is an infection in a patient, otherwise it is 0. Sometimes infections persist for seveal visits, sometimes they only remain for one visit and the patient is cured.I want to create 3 variables (X!, X2, X3) that would indicate a 1 or a 0 according to the following criteria: In other words, this is how is might look and what I which to have my program do: ID visit1 visit2 visit3 visit4 VARIABLE X1 VARIABLE X2 VARIABLE X3 1 0 0 0 0 0 0 0 2 0 1 0 0 0 1 0 3 1 1 0 0 1 1 0 4 0 1 1 1 1 1 1 5 0 1 0 1 0 1 0 X1) Variable is = 1 when there is an infection for At least two or more consecutive visits per patient. X2) Variable is = 1 when there is an infection for At least one visits per patient (Any infection). X3) Variable is = 1 when there is an infection for At least three or more consecutive visits per patient. Anyone can help me? I do not know how to solve this. Thank you Message was edited by: Ana Maria rodriguez
... View more