Hi all, I have two character variables (med1, med2) for medications prescribed in my dataset. I want to create a cleaner/rolled up third variable that aggregates all similar medications so that I can put this new variable into my logistic regression model. Med1 Med2 Buspirone 50mg. Citalopram chloride Buspirone 10mg. Buspirone 10 Buspirone. Citalopram 5mg Citalopram 20mg. Citalopram In the data, citalopram and buspirone are written many different ways, sometimes with dosages and full compound names. I am trying to creat a new variable, MedAgg, that combines all the instances these meds are prescribed into just buspirone and citalopram and from there I can assign them numerical values as my goal is to use Medagg as a categorical variable in my regression. Thanks in advance!
... View more