Association Between Red Cell Distribution Width and Hospital Mortality in Patients with Sepsis DOI: 10.1177/03000605211004221
They were my code for the extraction data in eICU-CRD database and statistical analysis in R. It was also my first project so the code maybe a little disorder. I learned a lot in this writing, and I will improve it next time. Thanks for Alistair Johnson(@mit-lcp). Follow these steps.
1. Request access to the eICU Collaborative Research Database(https://eicu-crd.mit.edu/gettingstarted/access/), download the database to your computer and install it.(Follow the instruction of https://github.com/MIT-LCP/eicu-code/tree/master/build-db/postgres)
2. run the sql code in the eicu github respiratory:(https://github.com/mit-lcp/eicu-code)
\i ../eicu-code/concepts/pivoted/pivoted-bg.sql
\i ../eicu-code/concepts/pivoted/pivoted-infusion.sql
\i ../eicu-code/concepts/pivoted/pivoted-lab.sql
\i ../eicu-code/concepts/pivoted/pivoted-med.sql
\i ../eicu-code/concepts/pivoted/pivoted-o2.sql
\i ../eicu-code/concepts/pivoted/pivoted-score.sql
\i ../eicu-code/concepts/pivoted/pivoted-treatment-vasopressor.sql
\i ../eicu-code/concepts/pivoted/pivoted-uo.sql
\i ../eicu-code/concepts/pivoted/pivoted-vital-other.sql
\i ../eicu-code/concepts/pivoted/pivoted-vital.sql
\i ../eicu-code/concepts/neuroblock.sql