Hi there, I was wondering if there is an easy way to find out whether a drug “parent” (ingredient level) has descendants of combination drugs. or in other words, if a descendant is also mapped to another ingredient. The reason is that I need pure drug concepts and it is a bit cumbersome to work through all the descendants (because there can be many). I need the descendants to perform the analysis though.
Thank you for any suggestions! PS. Atlas is very slow, I am using ATHENA right now.
If you mean in SQL, what I would suggest is the following:
Find drugs that are descended from a given parent ingredient concept (I think you have this)
For each drug, perform a subquery to find parents that are class = ‘Ingredient’. Call this ‘parent_ingredient’.
Group by drug_concept_id, count (distinct parent_ingredient)
Having count(distinct parent_ingredient) = 1
In simple terms: single ingredient drugs are those drugs that have a single ingredient parent.
thank you