Charlson Comorbid coding (pre ICD10)

The Charlson Comorbid score is calculated by different functions in different parts of CCMDB.

SAS coding macro comorbid3

The statistician has a SAS macro called "comorbid3" that calculates the score for data after import.

CCMBD.mdb

queries

  • s_charlson_score

sums the scores in

  • s_charlson__combined

which unions (ie no duplicates)

  • s_charlson_adm - list of scores for the highest-scoring admit dx per charlson category
  • s_charlson_como - list of scores for the highest-scoring comorbid dx per charlson category

function Charlson_score_function

The function Charlson_score_function (Pat_ID) in CCMDB.mdb looks up and returns the score in query s_charlsonScore.