Fetching ICD description and generating new variable

[Bader Bin Adwan]

Hi,

I have dataset that contains ICD 10 codes. What I want is to generate a new variable and fetching the description of each icd code next to it. I tried with icd10 lookup, generate(code_desc) but it did not work.

Any help is appreciated.

* Example generated by -dataex-. For more info, type help dataex
clear
input int year str4 icd101code byte countofstat_no
2018 "C719" 1
2018 "E147" 1
2018 "G713" 1
2018 "I619" 1
2018 "I81"  1
2018 "J09"  1
2018 "J100" 1
2018 "J129" 1
2018 "J189" 1
2018 "M628" 1
end

[Andrew Musau]

* Example generated by -dataex-. For more info, type help dataex
clear
input int year str4 icd101code byte countofstat_no
2018 "C719" 1
2018 "E147" 1
2018 "G713" 1
2018 "I619" 1
2018 "I81"  1
2018 "J09"  1
2018 "J100" 1
2018 "J129" 1
2018 "J189" 1
2018 "M628" 1
end

icd10 gen description= icd101code, description

Res.:

. l, sep(0)

     +-----------------------------------------------------------------------------------------------+
     | year   icd101~e   counto~o                                                        description |
     |-----------------------------------------------------------------------------------------------|
  1. | 2018       C719          1                             Malignant neoplasm: Brain, unspecified |
  2. | 2018       E147          1         Unspecified diabetes mellitus: With multiple complications |
  3. | 2018       G713          1                   Mitochondrial myopathy, not elsewhere classified |
  4. | 2018       I619          1                             Intracerebral haemorrhage, unspecified |
  5. | 2018        I81          1                                             Portal vein thrombosis |
  6. | 2018        J09          1   Influenza due to identified zoonotic or pandemic influenza virus |
  7. | 2018       J100          1      Influenza with pneumonia, seasonal influenza virus identified |
  8. | 2018       J129          1                                       Viral pneumonia, unspecified |
  9. | 2018       J189          1                                             Pneumonia, unspecified |
 10. | 2018       M628          1                                Other specified disorders of muscle |
     +-----------------------------------------------------------------------------------------------+

[Bader Bin Adwan]

Thank you so much Andrew