inst/QueryLibrary/Aggregate/measurement/ME01.md

In sib-swiss/dsQueryLibraryServer: OMOP query Library

ME01 Longitudinal measurements statistics

Description

Statistics for reoccuring measurements (more than 2 data points per person). Number of individuals, mean interval in days between first and last measurement, mean number of data points.

Query

select measurement_concept_id, unit_concept_id, cm.concept_name as measurement_name, cu.concept_name as unit_name,  
count(distinct person_id)::integer as n_individuals, round(avg(followup_points)) as mean_followup_points, round(avg(followup_days)) as mean_followup_days      
 from
    (select person_id, measurement_concept_id, unit_concept_id, count(distinct measurement_date) as followup_points,
     max(measurement_date) - min(measurement_date) as followup_days  from measurement
     where measurement_concept_id > 0
    group by person_id, measurement_concept_id, unit_concept_id
    having count(*)  > 2) m
inner join concept cm on m.measurement_concept_id = cm.concept_id
inner join concept cu on m.unit_concept_id = cu.concept_id
group by measurement_concept_id, unit_concept_id, cm.concept_name, cu.concept_name;

Input

None

Output

Example output record

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