Date:         Tue, 22 Feb 2005 14:23:16 -0800
Reply-To:     Jack Hamilton <jfh@STANFORDALUMNI.ORG>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jack Hamilton <jfh@STANFORDALUMNI.ORG>
Subject:      Re: Is there a sas code that can clean up ICD-9 codes?
Comments: To: Duck-Hye Yang <dyang@CHAPINHALL.ORG>
In-Reply-To:  <s21b4e07.081@eden.chapinhall.org>
Content-Type: text/plain; charset="us-ascii"; format=flowed

We found a great deal of variability in codes from claims data.  In our
most flexible mathcing algorithm, we tried adding one and then two zeros to
the end of codes that didn't match, and subtracting zeros off the end of
codes that didn't match.  So for

    315

we would try

    315, 3150, and 31500

For

    31500

we would try

    31500, 3150, and 315

And for

    3150

we would try

    3150, 31500, and 315

The easiest way to do this is with formats, but you could also use SET
codes KEY=lookupvalue.  If the codes were always numeric (not the case
here) you could also use SET xxx POINT=numericlookupvalue.  In V9, you
could use a hash table; I don't know whether that would be faster than
using a format, but my guess is that it would.



At 03:21 pm 2/22/2005 -0600, Duck-Hye Yang wrote:

>Thank you for your code!
>I will check if it is helpful for me.
>
>I posted my question because I was bothered the most by the following
>finding:
>Medicaid data has '3153','31530','31531','31532'.
>
>The CMS label you mentioned below has only 2 lables as valid ones--the
>last two: '31531','31532'.  These two belong to higher aggregation
>classification code , 74 other mental.
>
>The first three are not valid ICD-9 codes.  However, I think that they
>should not be classified 'missing'.
>I want to include them as 74 other mental.



-----
Jack Hamilton
jfh@alumni.stanford.org
Sacramento, California