OHDSI Home | Forums | Wiki | Github

How to separate only condition codes from concept_ancestor file?

(raghu) #1

Hi Folks,

I am working with the concept_ancestor file for my project. I would like to retain the concept_ID which belongs to conditions only in the file. Is there any way to segregate this file wrt to “conditions”, “procedure”.

(Anna Ostropolets) #2

You can join CONCEPT_ANCESTOR table to CONCEPT table twice on ancestror_concept_id and descendant_concept_id and filter by domain_id = Condition or Procedure and then download it as a table