Operate on Atlas cohorts and data with entries and exit events

Data extracted from Atlas contain cohort entry and cohort exit dates for each person in the cohort. Retaining this information may be important for the downstream analysis.

The Cohort Operations tool offers an option to include cohort entry and exit dates into newly created cohorts. It was presented in the FinnGen data users meeting 25th Jan 2022 (at 16min35sec) and FinnGen data users' meeting 28th June 2022 (at 28min55sec).

Tip: Preliminary exploration of cohorts prior CO can be done within Atlas using Atlas Cohort Characterizations tool. See an Example workflow for survival time/endpoint analysis.

Step 1:

First, Upload cohorts into the Cohort Operations tool. The uploaded cohorts will show up in the Cohorts workbench view. Then click Operate Cohorts on the left-hand menu. Guidance for each step is available from .

Step 2:

On the Operate Cohorts -> Select new cohort's entry and exit select entry rules for cohort start and end dates and select one or more cohorts where the data is taken from.

Example

In the following example, CO will select the earliest COHORT_START_DATE and the latest COHORT_END_DATE for a person from the Atlas cohorts included in from -box (Asthma[MN] or AllergicRhinitisOrNasalSteroids[MN]).

In this case, earliest cohort start date is either the first case of Asthma or the first case of Allergic Rhinitis whichever comes earlier for a person. Similarly, the latest cohort end date is from the cohort with latest recording.

The cohort start date defined by the user in Atlas is the approximate date (real date ± 1-15 days) when a person enters the cohort. Usually, the cohort start date is set (in Atlas) to some event e.g. first diagnosis for a condition, or e.g. first recorded event in a person's medical history.

Similarly, a cohort end date is defined by the user in Atlas. Note that the Cohort Operation tool selects the earliest or the latest COHORT_START_DATE and COHORT_END_DATE from the Atlas cohorts, those are indicated in the from -box above (here Asthma[MN] or AllergicRhinitisOrNasalSteroids[MN]).

Select rules for patient inclusion from Select new cohort's patients if you like. The selection of patients is optional and provides further filtering based on a cohort, see Combine cohorts with CO section. Click Create New Cohort.

The new combined cohort will appear in the Result cohort view. Here you can see the same summary statistics as when uploading cohorts from Atlas or from a file with a number of cases and blue and red bars for males and females. Cohort start and end dates are also included as indicated by the blue bars under COHORT_START_DATE and COHORT_END_DATE. Upload the new cohort directly to the workbench of the same session by clicking the Copy new cohort to workbench button.

On the Operate Cohorts -> Select new cohort's entry and exit users can select the earliest, the latest, or all entry events and earliest or latest exit events. For comparison let's repeat the cohort creation with the latest cohort start date and earliest cohort end date. Let's repeat the cohort also with all entry events.

Click and .

For comparison let's repeat the cohort also with all entry events.

Click and .

On the workbench, we have now three versions of the same cohort. The blue and red bars for males and females are the same in all versions as expected. However, the blue bars indicating cohort entry events are different depending on whether the earliest, the latest, or all entry events are selected.

After uploading the new cohorts to the workbench they are now ready for further operations like combining with other cohorts, exploration of code and endpoint enrichments, or export of the cohorts.

To export the cohort, see Export FinnGen IDs using CO. Cohorts are exported with FinnGen IDs, cohort start, and cohort end dates.

Tip: Cohorts created with CO can be uploaded and visualized for timeline trajectories per patient, clustered for HeatMap presentation, and overview plots can be created using Trajectory Visualization Tool (TVT).