Finding Broad Concepts

[ericaVoss]

This helped with the broad drugs:

"Broad" Drugs

@aostropolets, it’s a good approach but it will work in an ideal world where we assigned ATC’s to all the RxNorm concepts, look: select count(*) from concept c where c.concept_id not in ( select distinct c.concept_id from concept c join concept_ancestor a on a.descendant_concept_id = c.concept_id join concept x on a.ancestor_concept_id= x.concept_id and x.vocabulary_id =‘ATC’ where c.vocabulary_id = ‘RxNorm’ and c.concept_name like ‘%Sodium Chloride%’ and c.standard_concept = ‘S’ ) a…