Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down at the end of May, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: st: ICD9 to ICD10 converter utility?


From   "POPE, REBECCA" <RPOPE@uams.edu>
To   "'statalist@hsphsun2.harvard.edu'" <statalist@hsphsun2.harvard.edu>
Subject   RE: st: ICD9 to ICD10 converter utility?
Date   Fri, 21 Jan 2011 11:39:38 -0600

I do not know of any such utility in Stata. However, if you are working with U.S. medical claims data, you could accomplish what you are wanting by the following:

1. Download the ICD-9-CM & ICD-10-CM crosswalk text files from the U.S. Centers for Disease Control and Prevention's National Center for Health Statistic's website (here is the link for the current versions: ftp://ftp.cdc.gov/pub/Health_Statistics/NCHS/Publications/ICD10CM/2011/ ). The relevant .zip file is DiagnosisGEMs_2011.zip. *See the note below.

2. Choose the appropriate file to import. I recommend reading the PDF file supplied by the NCHS & included with the ZIP file referenced above. The data are in fixed format, so you can use -infix-. For simplicity, I recommend naming the first variable (they come without names) the same as your diagnosis code variable since this is what you'll be merging on. You can name the 2nd one whatever you like. I think the 3rd variable will be extraneous for your purpose.

3. Merge the imported file with your current data set. I don't know what version of Stata you are using, but if you need help with this, just type -help merge-.

You now have a dataset with your original diagnosis code & the alternate version (either 9 or 10). Hopefully your original codes are not a mix of 9s and 10s. If so, the process above is a bit more complex. Let me know if you need more information. 

As an aside: I am interested in working with someone to write an .ado file that could do the above and test it on multiple versions of Stata, so please let me know if you'd like to collaborate on that. I'm using version 11.1. 

*Note on ICD-9 vs ICD-9-CM (also for 10):
There is a difference between ICD-9 and ICD-9-CM. I mention the ICD-9-CM files because that's what I'm familiar with and there is a _chance_ that when you said "ICD-9" you meant "ICD-9-CM". Many of my colleagues don't specify "CM" until the publication stage even though it is the correct terminology in many cases for codes in the U.S. I'm far too often guilty myself! If you are in the U.S. & working with health insurance claims data, you are probably working with ICD-9-CM codes, which differ slightly from ICD-9 codes. 

To the best of my knowledge, the U.S. is the only country that uses the -CM coding system. Everyone else uses the standard ICD-9 system developed by the World Health Organization. For more information on the differences & to see if the crosswalk file above will still suit your purposes even with non-U.S. data, read http://www.cdc.gov/nchs/icd/icd9cm.htm and http://www.cdc.gov/nchs/icd/icd10cm.htm. If there are other health researchers who read this post & conduct research with non-U.S. data, please help. I know woefully little about how claims research is done outside the U.S. 

You might check the WHO site for an ICD-9 to ICD-10 crosswalk file.

Regards,
Rebecca

-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Neil Shephard
Sent: Friday, January 21, 2011 10:22 AM
To: statalist@hsphsun2.harvard.edu
Subject: Re: st: ICD9 to ICD10 converter utility?

On Fri, Jan 21, 2011 at 3:05 PM, roland andersson
<rolandersson@gmail.com> wrote:
> Dear Statalisters
>
> I wonder if there is a utility for Stata that can convert IC9 to ICD10
> codes or the other way (or in other program)? It would facilitate my
> work to only have one list of disease codes.

When I asked this question a few years back someone kindly forwarded
me a copy of a Stata dataset that they use which mapped ICD9 <-->
ICD10.

Unfortunately I no longer have the file as it resides on the network
drives of an old employer and I can't remember who it was who sent it
to me.

Sorry thats not much help,

Neil



-- 
"Truth in science can be defined as the working hypothesis best suited
to open the way to the next better one." - Konrad Lorenz

Email - nshephard@gmail.com
Website - http://kimura.no-ip.org/
Photos - http://www.flickr.com/photos/slackline/

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/
Confidentiality Notice: This e-mail message, including any attachments,
is for the sole use of the intended recipient(s) and may contain
confidential and privileged information.  Any unauthorized review,
use, disclosure or distribution is prohibited.  If you are not the 
intended recipient, please contact the sender by reply
e-mail and destroy all copies of the original message..


*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index