Hi all,

I'm new to Stata and would appreciate any direction here! I'm currently working with two files. One is a master list of Medicaid recipient cohort, and the second one is a list of prescription claims for some of those people in the Master list. Each beneficiary in the master file may have 0 up to hundreds of prescriptions in the second file. They are deidentified but both files contain a linked ID variable.

I was wondering if anyone had advice on how I could create the Rx measures at the person level, then add them as new variables to the master file.