Hi Experts, I am facing challenges with one of my activities. Please find below scenario and kindly provide the solution. Input Table: Patient Plan_TRT ACT_TRT_VIS2 ACT_TRT_VIS4 ACT_TRT_VIS5 ACT_TRT_VIS6 ACT_TRT_VIS21 ACT_TRT_VIS51 ACT_TRT_VIS41 101 TRTA 10MG TRTA 10MG 102 TRTA 10MG TRTA 10MG TRTA 5MG TRTB 10MG TRTB 10MG TRTB 10MG 103 TRTB 5MG TRTB 10MG TRTA 5MG TRTB 10MG TRTB 10MG TRTB 10MG TRTB 10MG 104 PLACEBO PLACEBO PLACEBO PLACEBO PLACEBO PLACEBO PLACEBO PLACEBO 105 TRTB 5MG TRTB 5MG TRTB 5MG 106 TRTA 10MG TRTA 5MG TRTA 10MG TRTA 10MG TRTA 10MG TRTA 10MG TRTA 10MG TRTA 10MG Output Table Required: (FINAL_ACTUAL_TRT is required) Patient Plan_TRT ACT_TRT_VIS2 ACT_TRT_VIS4 ACT_TRT_VIS5 ACT_TRT_VIS6 ACT_TRT_VIS21 ACT_TRT_VIS51 ACT_TRT_VIS41 FINAL_ACTUAL_TRT 101 TRTA 10MG TRTA 10MG TRTA 10MG 102 TRTA 10MG TRTA 10MG TRTA 5MG TRTB 10MG TRTB 10MG TRTB 10MG TRTB 5MG 103 TRTB 5MG TRTB 10MG TRTA 5MG TRTB 10MG TRTB 10MG TRTB 10MG TRTB 10MG TRTB 5MG 104 PLACEBO PLACEBO PLACEBO PLACEBO PLACEBO PLACEBO PLACEBO PLACEBO PLACEBO 105 TRTB 5MG TRTB 5MG TRTB 5MG TRTB 5MG 106 TRTA 10MG TRTA 5MG TRTA 10MG TRTA 10MG TRTA 10MG TRTA 10MG TRTA 10MG TRTA 10MG TRTA 10MG Conditions: It is for Patient 101 - If patient received Plan_TRT treatment at ACT_TRT_VIS2 and other Vists are blank then Fina_Actual_TRT value would be the value of ACT_TRT_VIS2 = Plan_TRT that is “TRTA 10MG” It is for Patient 102 - If patient received Plan_TRT treatment at ACT_TRT_VIS2 (TRTA 10MG) but at ACT_TRT_VIS4 received a different treatment (TRTA 5MG) again at ACT_TRT_VIS5 switched back to ACT_TRT_VIS2 value and continued the same treatment for all the visits then FINAL_ACTUAL_TRT = Plan_TRT (TRTA 10MG) It is for Patient 103 - If patient received different treatment than Plan_TRT (TRTA 10MG) at ACT_TRT_VIS2 (TRTB 5MG) and changes to Plan_TRT at VIS4 and again moved to ACT_TRT_VIS2 value and continued to rest of visits with the same value then FINAL_ACTUAL_TRT = Plan_TRT (that is “TRTB 5MG”). It is for Patient 106 – If patient not received plan_TRT at ACT_TRT_VIS2 but later continued with Plan_TRT value then FINAL_ACTUAL_TRT = Plan_TRT (that is “TRTA 10MG”) If patient received Plan_TRT for all then ACTUAL_TRT = Plan_TRT I googled and trying to approach with below code. 1. Finding if all variables are have same values or not. If all records are having same values then planning to assign FINAL_ACTUAL_TRT = Plan_TRT . data want; set test3; array c{*} $ VIS2 VIS4 VIS5 VIS6 VIS21 VIS51 VIS41; if cmiss(of c{*})=0 then result='same'; else result='diff'; do I=2 to dim(c) while (result='same'); if c{i}^=c{i-1} then result='diff'; end; run; If different values are there for visits then planning to take them to separate table and apply IF conditions. (But, I feel that is a lengthy approach. Requesting you to provide the better solution for me. Thanks you very much in advance for your support. Kind Regards, RJ
... View more