Hi, I need some help here. I am trying to compare values of a visit variable in one dataset(Assessment )with that of a variable in another dataset(Treatment) to populate the treatment the subject was having during that visit. Assessment: ID VISIT VISDT A 1 10 A 2 11 A 3 12 B 1 11 B 2 12 B 3 13 Treatment: ID TRT TRTDT A x 9 A x 10 A y 11 A x 12 B x 11 B y 12 B y 14 B x 15 I am trying to compare the VISDT from Assessment dataset with that of the Treatment dataset. If the VISIDT is equal to or between the TRTDT then I want the respective TRT values populated for Assessment dataset. Thanks in advance.
... View more