We want to join the Medicare spending data sets with the USP drug classification so that we can relate drug spending to therapeutic indications. I will be starting with the USP drug classification because we find that their description is more accessible than ATC (which is more technical).
What we're looking for
I want to join the Medicare drugname_generic with either usp_drug or drug_example. The usp_drug is the active ingredient and drug_example is the salt and/or formulations. I think the drugname_generic is also just the active ingredient.
How this will help
Joining these datasets will allow us to group therapeutic indication to Medicaid drug spending.
Status
Assigned to myself
Task
We want to join the Medicare spending data sets with the USP drug classification so that we can relate drug spending to therapeutic indications. I will be starting with the USP drug classification because we find that their description is more accessible than ATC (which is more technical).
What we're looking for
I want to join the Medicare
drugname_genericwith eitherusp_drugordrug_example. Theusp_drugis the active ingredient anddrug_exampleis the salt and/or formulations. I think thedrugname_genericis also just the active ingredient.How this will help
Joining these datasets will allow us to group therapeutic indication to Medicaid drug spending.