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.
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).
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.
The SQL Elixhauser code was efficient and computationally identical to the SAS algorithm used for the NRD.
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.
This research output has an Altmetric Attention Score of 1. This is our high-level measure of the quality and quantity of online attention that it has received. This Attention Score, as well as the ranking and number of research outputs shown below, was calculated when the research output was last mentioned on 30 March 2017.
All research outputs
#18,540,642
of 22,962,258 outputs
Outputs from Journal of the American Medical Informatics Association
#2,835
of 3,078 outputs
Outputs of similar age
#235,472
of 306,992 outputs
Outputs of similar age from Journal of the American Medical Informatics Association
#44
of 46 outputs
Altmetric has tracked 22,962,258 research outputs across all sources so far. This one is in the 11th percentile – i.e., 11% of other outputs scored the same or lower than it.
So far Altmetric has tracked 3,078 research outputs from this source. They typically receive a lot more attention than average, with a mean Attention Score of 14.0. This one is in the 2nd percentile – i.e., 2% of its peers scored the same or lower than it.
Older research outputs will score higher simply because they've had more time to accumulate mentions. To account for age we can compare this Altmetric Attention Score to the 306,992 tracked outputs that were published within six weeks on either side of this one in any source. This one is in the 12th percentile – i.e., 12% of its contemporaries scored the same or lower than it.
We're also able to compare this research output to 46 others from the same source and published within six weeks on either side of this one. This one is in the 2nd percentile – i.e., 2% of its contemporaries scored the same or lower than it.
