Drug Exposure‎ > ‎

DEX08: Maximum number of distinct drugs per person over some time period

This query is to determine the maximum number of distinct drugs a patient is exposed to during a certain time period. If the time period is omitted, the entire time span of the database is considered. See vocabulary queries for obtaining valid drug_concept_id values.

Input:
 Parameter Example Mandatory Notes
date from
01-Jan-2008Yes

date to31-Dec-2008Yes 

Sample query run:
The following is a sample run of the query. The input parameters are highlighted in blue.

SELECT max( drugs ) AS drugs_count
  FROM -- person, drug exposures over a year
     ( SELECT person_id, COUNT( DISTINCT drug_concept_id ) drugs
         FROM drug_exposure
        WHERE drug_exposure_start_date BETWEEN '01-Jan-2008' AND '31-Dec-2008'
        GROUP BY person_id
     );
Output:
Output field list:
 Field  Description
drugs_count
 The maximum number of distinct drugs a patient is exposed to during the time period

Sample output record:
 Field  Content
drugs_count
 141
Comments