Help needed coding lists of comorbidity into ICD code

[WJU]

Dear all
Can, anyone help?
I have an excel and SPSS data sheet with 12,000+ cases
My problem is I have a text list of comorbidity for each case and need to covert it to a ICD code so I can calculate a Charlson score
My project is comparing mortality across 3 groups but I will need to control for pre-existing conditions and therefore need to code these
There are too many to find and replace or transform variable with a number

 

[Karabiner]

The Charlson index includes less then 20 diagnoses, some with severity ratings, right?
And it does not require ICD codes, AFAIK. What do the existing entries for comorbidity
look like, could you give some examples?

With kind regards

Karabiner

 

[WJU]

Hypertension, adrenal cancer, Diabetes, IHD

 

[WJU]

The Charlson index includes less then 20 diagnoses, some with severity ratings, right? Correct

 

[Karabiner]

So what do you need the icd diagnosis for?

You can use CHAR.SUBSTR in SPSS, e.g. to creatie a new variable diabetes
and to assign it the value 1, if the condition variable contains the string "diabetes":
STRING diabetes (A12).
IF(CHAR.SUBSTR(condition_variable,"diabetes") > 0) diabetes = 1.

With kind regards

Karabiner

 

[WJU]

Thank you that's much appreciated!