Hi all,
Does anyone have a proc format statement that assigns the cause of death description the three-digit ICD-9 code? I have this for ICD-9-CM (hospitalization data) but looking specifically for ICD-9 for Mortality.
Thank you!
@lstockman wrote:
Thanks ballardw! I have the ucod.txt doc, and am trying to work with it. NCHS has stripped out the E and the decimal in the data I have so external codes are reported beginning with 800. I will consider the 4th digit. Was hoping to find the same info in the txt doc in a more usable format.
I've made a few searches over the past 10 years or so but have never found a "clean" data file of any sort for either ICD-9 or ICD-10 except for smallish subsets of topics.
i doubt that anyone has a format stored here with ICD-9 codes. Do you have the codes now? And how are they stored?
If you have a reference list for those codes, it's very easy to create a format from that.
ftp://ftp.cdc.gov/pub/Health_Statistics/NCHS/Publications/ICD-9
has codes "modified for use by the United States" as a text document. There are notes about codes groups that have been excluded so you may be able to recreate some of those if you need them. It sounds like you may only be looking for the no decimal levels which reduces the number codes but are a tad harder to read from that (not well structured for data set use) text file
Read the text document ucod.txt into a data set and use the information as a CNTLIN data set for proc format.
I'm not aware of a nicer source with relatively complete codes.
@lstockman wrote:
Hi all,
Does anyone have a proc format statement that assigns the cause of death description the three-digit ICD-9 code? I have this for ICD-9-CM (hospitalization data) but looking specifically for ICD-9 for Mortality.
Thank you!
If you only use 3 digits your codes are incomplete. You will likely need 4 characters to accommodate codes such as
E800 Railway accident involving collision with rolling stock
Thanks ballardw! I have the ucod.txt doc, and am trying to work with it. NCHS has stripped out the E and the decimal in the data I have so external codes are reported beginning with 800. I will consider the 4th digit. Was hoping to find the same info in the txt doc in a more usable format.
@lstockman wrote:
Thanks ballardw! I have the ucod.txt doc, and am trying to work with it. NCHS has stripped out the E and the decimal in the data I have so external codes are reported beginning with 800. I will consider the 4th digit. Was hoping to find the same info in the txt doc in a more usable format.
I've made a few searches over the past 10 years or so but have never found a "clean" data file of any sort for either ICD-9 or ICD-10 except for smallish subsets of topics.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.