[WIP] Join Medicare data to USP drug classification

[ChayaSt]

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_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.