Drug Exposure‎ > ‎

DEX17: Why do people stop treatment?

This query provides a list of stop treatment and their frequency.


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

SELECT stop_reason, count(*) AS reason_freq
  FROM drug_exposure 
 WHERE stop_reason IS NOT null 
 GROUP BY stop_reason 
 ORDER BY reason_freq DESC;


Output field list:
 Field  Description
stop_reason The reason the medication was stopped, where available. Reasons include regimen completed, changed, removed, etc.
reason_freq  Frequency of stop reason

Sample output record:
 Field  Description
stop_reason  Regimen Completed
reason_freq  14712428