BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
lstockman
Fluorite | Level 6

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!

 

1 ACCEPTED SOLUTION

Accepted Solutions
ballardw
Super User

@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.

View solution in original post

5 REPLIES 5
PeterClemmensen
Tourmaline | Level 20

i doubt that anyone has a format stored here with ICD-9 codes. Do you have the codes now? And how are they stored?

ballardw
Super User

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

lstockman
Fluorite | Level 6

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. 

ballardw
Super User

@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.

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 5 replies
  • 846 views
  • 0 likes
  • 4 in conversation