Richard H Epstein1, Franklin Dexter2. 1. Department of Anesthesiology, Perioperative Medicine and Pain Management, University of Miami, Miami, FL, USA. 2. Division of Management Consulting, Department of Anesthesia, University of Iowa, Iowa City, IA, USA.
Abstract
OBJECTIVE: Comorbidity adjustment is often performed during outcomes and health care resource utilization research. Our goal was to develop an efficient algorithm in structured query language (SQL) to determine the Elixhauser comorbidity index. MATERIALS AND METHODS: We wrote an SQL algorithm to calculate the Elixhauser comorbidities from Diagnosis Related Group and International Classification of Diseases (ICD) codes. Validation was by comparison to expected comorbidities from combinations of these codes and to the 2013 Nationwide Readmissions Database (NRD). RESULTS: The SQL algorithm matched perfectly with expected comorbidities for all combinations of ICD-9 or ICD-10, and Diagnosis Related Groups. Of 13 585 859 evaluable NRD records, the algorithm matched 100% of the listed comorbidities. Processing time was ∼0.05 ms/record. DISCUSSION: The SQL Elixhauser code was efficient and computationally identical to the SAS algorithm used for the NRD. CONCLUSIONS: This algorithm may be useful where preprocessing of large datasets in a relational database environment and comorbidity determination is desired before statistical analysis. A validated SQL procedure to calculate Elixhauser comorbidities and the van Walraven index from ICD-9 or ICD-10 discharge diagnosis codes has been published.
OBJECTIVE: Comorbidity adjustment is often performed during outcomes and health care resource utilization research. Our goal was to develop an efficient algorithm in structured query language (SQL) to determine the Elixhauser comorbidity index. MATERIALS AND METHODS: We wrote an SQL algorithm to calculate the Elixhauser comorbidities from Diagnosis Related Group and International Classification of Diseases (ICD) codes. Validation was by comparison to expected comorbidities from combinations of these codes and to the 2013 Nationwide Readmissions Database (NRD). RESULTS: The SQL algorithm matched perfectly with expected comorbidities for all combinations of ICD-9 or ICD-10, and Diagnosis Related Groups. Of 13 585 859 evaluable NRD records, the algorithm matched 100% of the listed comorbidities. Processing time was ∼0.05 ms/record. DISCUSSION: The SQL Elixhauser code was efficient and computationally identical to the SAS algorithm used for the NRD. CONCLUSIONS: This algorithm may be useful where preprocessing of large datasets in a relational database environment and comorbidity determination is desired before statistical analysis. A validated SQL procedure to calculate Elixhauser comorbidities and the van Walraven index from ICD-9 or ICD-10 discharge diagnosis codes has been published.
Authors: Hude Quan; Vijaya Sundararajan; Patricia Halfon; Andrew Fong; Bernard Burnand; Jean-Christophe Luthi; L Duncan Saunders; Cynthia A Beck; Thomas E Feasby; William A Ghali Journal: Med Care Date: 2005-11 Impact factor: 2.983
Authors: Swetha Pasala; Lauren B Cooper; Mitchell A Psotka; Shashank S Sinha; Christopher R deFilippi; Henry Tran; Behnam Tehrani; Matthew Sherwood; Kelly Epps; Wayne Batchelor; Abdulla A Damluji Journal: Am Heart J Date: 2021-12-16 Impact factor: 4.749
Authors: Abdulla A Damluji; Michael Fabbro; Richard H Epstein; Stefan Rayer; Ying Wang; Mauro Moscucci; Mauricio G Cohen; John D Carroll; John C Messenger; Jon R Resar; David J Cohen; Matthew W Sherwood; Christopher M O'Connor; Wayne Batchelor Journal: Circ Cardiovasc Qual Outcomes Date: 2020-08-19