search

OHDSI / Atlas

ATLAS is an open source software tool for researchers to conduct scientific analyses on standardized observational data
http://atlas-demo.ohdsi.org/
Apache License 2.0
265 stars 134 forks source link

Atlas incidence rate analysis: unable to stratify by unknown race/ethnicity #2636

Open jaanli opened 2 years ago

jaanli commented 2 years ago

Expected behavior

I am trying to replicate work in this table: https://journals.lww.com/greenjournal/Fulltext/2020/11000/Associations_Between_Comorbidities_and_Severe.5.aspx

image

Actual behavior

There is no way to select 'unknown ethnicity or race' - despite manually confirming via SQL queries that most patients in a CDM have race unknown, the incidence analysis reports 0 patients for the below stratification:

image

Steps to reproduce behavior

  1. Create any incidence rate analysis in Atlas
  2. Stratify by demographic criteria for race unknown
  3. Try to stratify by ethnicity criteria unknown
  4. Generate a report
  5. See that there are 0 records with unknown race/ethnicity

Screenshot of stratification criteria:

image

(Right now I am solving this issue by subtracting the total from the known race/ethnicity values)

chrisknoll commented 1 year ago

I was going to suggest that we implement the 'not in' logic on race and ethnicity concepts so you could say 'not in' {the other list of concepts), but we didn't implement not-in logic on those fields. But, fi we did, this would satisfy your needs.