inst/QueryLibrary/Aggregate/drug_era/DER05.md

In sib-swiss/dsQueryLibraryServer: OMOP query Library

DER05: For a given indication, what proportion of patients take each indicated treatment?

Description

Query

SELECT tt.concept_id, tt.concept_name, 100*(tt.cntPersons*1.0/tt.total*1.0)::numeric AS proportion FROM (
SELECT c.concept_id, c.concept_name, t.cntPersons, cast(sum(cntPersons) over() as integer) AS total
FROM @vocab.concept c,
(SELECT er.drug_concept_id, count(DISTINCT er.person_id)::integer AS cntPersons
FROM  @vocab.concept_relationship cr,
         @vocab.concept_ancestor ca,
      @cdm.drug_era er
WHERE cr.concept_id_1 = ca.descendant_concept_id
  and er.drug_concept_id = ca.ancestor_concept_id
  and cr.concept_id_2 = $1

  and cr.relationship_id IN ('Has FDA-appr ind', 'Has off-label ind', 'May treat', 'May prevent', 'CI by', 'Is off-label ind of', 'Is FDA-appr ind of', 'May be treated by')
GROUP BY er.drug_concept_id, cr.concept_id_2
) t
WHERE t.drug_concept_id = c.concept_id
) tt

Input

| Parameter | Example | Mandatory | Notes | | --- | --- | --- | --- | | concept_id | 21001738 | Yes | Cold Symptoms |

Output

| Field | Description | | --- | --- | | Concept_id | Unique identifier for drug concept | | Concept_name | Standardized drug name | | Proportion | Drug that proportion of patients take |

Example output record

| Field | Value | | --- | --- | | Concept_id | 1126658 | | Concept_name | Hydromorphone | | Proportion | 0.63270536909000900 |

Documentation

https://github.com/OHDSI/CommonDataModel/wiki/

sib-swiss/dsQueryLibraryServer documentation built on Feb. 13, 2025, 8:07 p.m.