inst/QueryLibrary/Assign/concept_name/drug_exposure.md
In sib-swiss/dsQueryLibraryServer: OMOP query Library
drug_exposure
Description
This query loads the drug_exposure table and adds a few useful columns by joining it to the concept table.
Query
SELECT d_name.concept_name as drug_name, d_type.concept_name as drug_type, d.*
FROM @cdm.drug_exposure AS d
LEFT JOIN @vocab.concept as d_name ON d.drug_concept_id = d_name.concept_id
LEFT JOIN @vocab.concept as d_type ON d.drug_type_concept_id = d_type.concept_id
sib-swiss/dsQueryLibraryServer documentation built on Feb. 13, 2025, 8:07 p.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
drug_exposure
Description
This query loads the drug_exposure table and adds a few useful columns by joining it to the concept table.
Query
SELECT d_name.concept_name as drug_name, d_type.concept_name as drug_type, d.*
FROM @cdm.drug_exposure AS d
LEFT JOIN @vocab.concept as d_name ON d.drug_concept_id = d_name.concept_id
LEFT JOIN @vocab.concept as d_type ON d.drug_type_concept_id = d_type.concept_id
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.