How to get the data set of NDC.RxNorm,ATC ATC to realize the mapping from ndc to ATC.

[33Wade33]

‘’‘ndc.vocabulary_id as vocabulary1_id
, ndc.concept_class_id as NDC_class_id
, ndc.concept_id as NDC_concept_id
, ndc.concept_name as NDC_concept_name
, ndc.concept_code as NDC_concept_code
, rela.relationship_id as relationship12_id
, rxnorm.vocabulary_id as rxnorm_vocabulary_id
, rxnorm.concept_class_id as rxnorm_concept_class_id
, rxnorm.concept_id as rxnorm_concept_id
, rxnorm.concept_name as rxnorm_concept_name
, rxnorm.concept_code as rxnorm_concept_code
--, relb.relationship_id as relationship23_id
, rxnorm_ing.concept_class_id as ing_concept_class_id
, rxnorm_ing.concept_id as ing_concept_id
, rxnorm_ing.concept_name as ing_concept_name
, atcl5.vocabulary_id as atcl5_vocabulary_id
, atcl5.concept_class_id as atcl5_concept_class_id
, atcl5.concept_id as atcl5_concept_id
, atcl5.concept_name as atcl5_concept_name
, atcl5.concept_code as atcl5_concept_code’‘’

I also hope to realize the mapping from ndc to ATC.
Thank you very much for your understanding. Thank you very much for your understanding. May I ask you a favor? I haven't found these three datasets for a long time. Where can I get them?

[PouyanJay]

The three vocabularies you're looking for (NDC, RxNorm, ATC) aren't shipped in this repository, they're downloaded from Athena, OHDSI's vocabulary distribution service:

1. Register at https://athena.ohdsi.org/ (free).
2. Click Download, and tick NDC, RxNorm, RxNorm Extension, and ATC (plus the default standard vocabularies already selected).
3. You'll receive a zip of CSV files (CONCEPT.csv, CONCEPT_RELATIONSHIP.csv, CONCEPT_ANCESTOR.csv, …) to load into your CDM vocabulary tables.

Once loaded, the NDC → ATC mapping is a two-step path:

-- Step 1: NDC -> RxNorm (standard concept) via 'Maps to'
-- Step 2: RxNorm -> ATC via CONCEPT_ANCESTOR (ATC classes are ancestors of RxNorm drugs)
SELECT
  ndc.concept_code      AS ndc_code,
  rxnorm.concept_id     AS rxnorm_concept_id,
  rxnorm.concept_name   AS rxnorm_name,
  atc.concept_code      AS atc_code,
  atc.concept_name      AS atc_name
FROM concept ndc
JOIN concept_relationship cr
  ON cr.concept_id_1 = ndc.concept_id AND cr.relationship_id = 'Maps to'
JOIN concept rxnorm
  ON rxnorm.concept_id = cr.concept_id_2
JOIN concept_ancestor ca
  ON ca.descendant_concept_id = rxnorm.concept_id
JOIN concept atc
  ON atc.concept_id = ca.ancestor_concept_id
 AND atc.vocabulary_id = 'ATC'
 AND atc.concept_class_id = 'ATC 5th'   -- drop this line to get all ATC levels
WHERE ndc.vocabulary_id = 'NDC'
  AND ndc.concept_code = '<your NDC code>';

Note that one NDC can map to multiple ATC classes (combination drugs, or ingredients used in several therapeutic groups), so expect one-to-many results. For vocabulary questions like this, the OHDSI forums and the Athena/vocabulary documentation are also good resources.