Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: ICD9 to ICD10 converter utility?
From
roland andersson <[email protected]>
To
[email protected]
Subject
Re: st: ICD9 to ICD10 converter utility?
Date
Sat, 22 Jan 2011 20:19:31 +0100
Thank you Rebecca
Very handy advices.
Roland
2011/1/21 POPE, REBECCA <[email protected]>:
> 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: [email protected] [mailto:[email protected]] On Behalf Of Neil Shephard
> Sent: Friday, January 21, 2011 10:22 AM
> To: [email protected]
> Subject: Re: st: ICD9 to ICD10 converter utility?
>
> On Fri, Jan 21, 2011 at 3:05 PM, roland andersson
> <[email protected]> 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 - [email protected]
> 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/
>
*
* 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/