Standardize Medicaid State Drug Utilization Data at the ingredient and clinical-drug level so quarterly utilization and reimbursement can be compared across product codes.
The data problem
SDUD is reported by NDC, which is precise for billing but fragmented for analysis. Generic equivalents, package sizes, and labelers can appear as separate products even when they represent the same ingredient and strength.
The analyzable result
Add RxNorm ingredients, Semantic Clinical Drugs, strengths, and dose forms to SDUD rows. You can then summarize units reimbursed and payment amounts at a clinically meaningful level while preserving the source NDC.
Three steps
Export the product or NDC field from the quarters and states included in your analysis.
Upload the unique NDC list to RxMap and preview the resulting RxNorm enrichment before checkout.
Merge the downloaded workbook back on NDC and aggregate by ingredient, clinical drug, state, or quarter.
Verified example
| ndc_code | IN_ingredient | SCD_semantic_clinical_drug | Strength |
|---|---|---|---|
| 00093-1048-01 | Metformin | Metformin hydrochloride 500 MG Oral Tablet | 500 MG |
| 00071-0155-23 | Atorvastatin | Atorvastatin 10 MG Oral Tablet | 10 MG |
| 00054-8174-25 | Dexamethasone | Dexamethasone 1 MG Oral Tablet | 1 MG |
Example mappings were checked against the public NIH NLM RxNorm API. Always review unmatched and retired NDC values when analyzing historical quarters.
Preview your mapped rows before payment. $0.001 per NDC, with a $1 minimum and $25 maximum per upload.
Start converting