Turn the product-level NDC values in MEPS prescribed medicines files into standardized ingredients, clinical drugs, strengths, and dose forms—without building an RxNav pipeline.
The data problem
MEPS prescribed medicines files identify dispensed products with NDC values. Manufacturer, formulation, and package differences can split the same clinical drug across many codes, making ingredient-level utilization and expenditure analysis difficult.
The analyzable result
Append RxNorm fields to your working file, then group prescriptions by ingredient or Semantic Clinical Drug while retaining the original NDC and MEPS variables for survey-weighted analysis.
Three steps
Prepare a CSV, Excel, or TSV file containing the NDC values from your MEPS prescribed medicines extract.
Select the NDC column. RxMap normalizes the values and retrieves current RxNorm concepts in bulk.
Download the enriched workbook and merge the new drug fields back into your MEPS analysis file.
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. RxNorm content changes over time; use your downloaded result as the record of the mapping run.
Preview your mapped rows before payment. $0.001 per NDC, with a $1 minimum and $25 maximum per upload.
Start converting