8000 MIMIC IV：blood_differential.sql has an error · Issue #1208 · MIT-LCP/mimic-code · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content

MIMIC IV：blood_differential.sql has an error #1208

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom
Closed
duanxiangjie opened this issue Dec 13, 2021 · 1 comment
Closed

MIMIC IV：blood_differential.sql has an error #1208

duanxiangjie opened this issue Dec 13, 2021 · 1 comment

Comments

@duanxiangjie
Copy link

Prerequisites

Description

The materialized view (blood_differential.sql) has an error, as follows:

, ROUND(CASE
WHEN basophils_abs IS NULL AND basophils IS NOT NULL AND impute_abs = 1
THEN basophils * wbc ---- basophils * wbc / 100
ELSE basophils_abs
END, 4) AS basophils_abs
, ROUND(CASE
WHEN eosinophils_abs IS NULL AND eosinophils IS NOT NULL AND impute_abs = 1
THEN eosinophils * wbc ----- eosinophils * wbc / 100
ELSE eosinophils_abs
END, 4) AS eosinophils_abs
, ROUND(CASE
WHEN lymphocytes_abs IS NULL AND lymphocytes IS NOT NULL AND impute_abs = 1
THEN lymphocytes * wbc ---- lymphocytes * wbc / 100
ELSE lymphocytes_abs
END, 4) AS lymphocytes_abs
, ROUND(CASE
WHEN monocytes_abs IS NULL AND monocytes IS NOT NULL AND impute_abs = 1
THEN monocytes * wbc ---- monocytes * wbc / 100
ELSE monocytes_abs
END, 4) AS monocytes_abs
, ROUND(CASE
WHEN neutrophils_abs IS NULL AND neutrophils IS NOT NULL AND impute_abs = 1
THEN neutrophils * wbc ---- neutrophils * wbc / 100
ELSE neutrophils_abs
END, 4) AS neutrophils_abs
@duanxiangjie duanxiangjie changed the title MIMIC IV：blood_differential has an error MIMIC IV：blood_differential.sql has an error Dec 13, 2021
@alistairewj alistairewj mentioned this issue Dec 17, 2021
Merged
alistairewj added a commit that referenced this issue Dec 17, 2021
@alistairewj
Merge pull request #1216 from MIT-LCP/blood_diff_fix
2af6930 
fix imputation of abs cell counts, closes #1208
@alistairewj
Copy link
Member

thanks! will be fixed on bigquery when we next push a release (soon-ish, likely within the week).

alistairewj added a commit that referenced this issue Jan 15, 2023
@alistairewj
fix imputation of abs cell counts, closes #1208
23417da
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@alistairewj @duanxiangjie
0