inst/QueryLibrary/Assign/concept_name/procedure.md
In sib-swiss/dsQueryLibraryServer: OMOP query Library
procedure_occurrence
Description
This query loads the "procedure_occurrence" table and adds a few useful columns by joining it to the concept table.
Query
SELECT p.*, p_name.concept_name as procedure_name, p_type.concept_name as procedure_type
FROM @cdm.procedure_occurrence AS p
LEFT JOIN @vocab.concept as p_name ON p.procedure_concept_id = p_name.concept_id
LEFT JOIN @vocab.concept as p_type ON p.procedure_type_concept_id = p_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.
procedure_occurrence
Description
This query loads the "procedure_occurrence" table and adds a few useful columns by joining it to the concept table.
Query
SELECT p.*, p_name.concept_name as procedure_name, p_type.concept_name as procedure_type
FROM @cdm.procedure_occurrence AS p
LEFT JOIN @vocab.concept as p_name ON p.procedure_concept_id = p_name.concept_id
LEFT JOIN @vocab.concept as p_type ON p.procedure_type_concept_id = p_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.