inst/shinyApps/QueryLibrary/queries/obervation_period/OP18.md

In OHDSI/QueryLibrary: A Query Library for the OMOP-CDM

OP18: Counts of observation period records stratified by start of observation month

Description

This query is used to count the observation period records stratified by observation month and person end. person end is an indicator whether a person has initiated the first observation period in a given observation month. All possible values are summarized.

Query

WITH observation_period_month AS
  ( SELECT
      MONTH(observation_period_start_date) AS observation_month
      FROM @cdm.observation_period
  )
SELECT
  observation_month,
  COUNT(*)                             AS num_observations
FROM observation_period_month
GROUP BY observation_month
ORDER BY 1;

Input

None

Output

| Field | Description | | --- | --- | | observation_month | Month of start of observation period | | num_observations | Number of observations within specific month of observation |

Example output record

| Field | Description | | --- | --- | | observation_month | 1 | | num_observations | 3987706 |

Documentation

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

OHDSI/QueryLibrary documentation built on Aug. 1, 2023, 5:42 a.m.