Question
Find patients who have a diagnosis of Acute MI documented at any time in their history and they have a medication with a dose greater than 500 mg and a medication that is taken once a day documented during the same instance.
Result
There are 3 patients who have had
- A medication with a dose of 500 mg and
- AND a frequency of once a day entered as a fact in the observation_fact table
- Where the medication dose and frequency have the same encounter_num , concept_cd, provider_id, start_date, AND instance_num
- AND the diagnosis of acute MI
- AND the medication dose and frequency all have the same patient_num
Step-by-step guide
Related articles
