inst/QueryLibrary/Aggregate/vocabulary/V02.md

In sib-swiss/dsQueryLibraryServer: OMOP query Library

V02: Measurement statistics

Description

Distribution of measurement and unit codes

Query

select
cm.concept_name as test_name
,cu.concept_name as unit_name
,cm.concept_id as test_concept_id
,cu.concept_id as unit_concept_id
, min (measurement.value_as_number)::numeric as min_value
, max (measurement.value_as_number)::numeric as max_value
, avg (measurement.value_as_number)::numeric as avg_value
, stddev (measurement.value_as_number)::numeric as stddev_value
, count(1)::integer as cnt
from measurement
left join concept cm on cm.concept_id = measurement.measurement_concept_id
left join concept cu on cu.concept_id = measurement.unit_concept_id
group by cm.concept_name,cu.concept_name, cm.concept_id,cu.concept_id
order by 1

Input

None

Output

| Field | Description | | --- | --- | | test_name| Test concept name | | unit_name | Unit concept name | | test_concept_id | Concept ID of the test| | unit_concept_id | Concept ID in the unit | | min_value | | | max_value| | | avg_value| | | stddev_value| Standard deviation |

sib-swiss/dsQueryLibraryServer documentation built on Feb. 13, 2025, 8:07 p.m.