inst/QueryLibrary/Aggregate/observation_period/OP05.md

In sib-swiss/dsQueryLibraryServer: OMOP query Library

OP05: Average length of observation, in month.

Description

Count average length of observation period in months.

Query

SELECT 
  FLOOR(AVG((observation_period_end_date - observation_period_start_date)/30)) AS num_months
FROM @cdm.observation_period;

Input

None

Output

| Field | Description | | --- | --- | | num_months | Average length of observation, in month |

Example output record

| Field | Value | | --- | --- | | num_months | 30 |

Documentation

https://github.com/OHDSI/CommonDataModel/wiki/

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