I have a data set below: Patient ID Drug 1 Drug 2 Drug 3 Drug 4 Drug 5 Drug 6 Drug 7 1 Statin Statin BB ACEI Statin 2 BB BB BB 3 Statin BB BB 4 ACEI Statin ACEI ACEI 5 ACEI BB 6 Statin Statin Statin 7 BB How do I create another variable (Total med) where: If Statin and BB and ACEI are in at least one of the 7 columns, then Total Med = Triple If ONLY Statin and BB are in at least one of 7 columns, then Total Med = Double_SB If ONLY Statin and ACEI are in at least one of 7 columns, then Total Med = Double_SA If ONLY Statin appeared in at least one of 7 columns, then Total Med = Statin alone If ONLY BB appeared in at least one of 7 columns, then Total Med = BB alone If ONLY ACEI appeared in at least one of 7 columns, then Total Med = ACEI alone
... View more