I send you a new example. For each patient, at M00 the traitment is missing it's normal because the patient haven't traitment before. But if the visits are not M00, M03,M06, M09 ... but tests between two visits as M06-M09 or M9-M12 or M3-M6. We must have the traitment the patient have indicate taked at the next visit (because we don't know the traitment actually taken). The patient indicate the traitment taked at visits M09, M12 and M9 in this case). I want to have this result For test at M06-M09 I put the value of M09 it's the next visit, for test at M09-M12, I put the value of M12 visit and for the test at M03-M06 I put the value of traitment of M12 visit because it's the next visit ... I hope it's clear ... Thanks for your help Marilyn
... View more