Date:         Fri, 29 Sep 2000 14:44:00 -0400
Reply-To:     Jack Shoemaker <JShoemaker@ACCORDANT.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jack Shoemaker <JShoemaker@ACCORDANT.NET>
Subject:      Re: Relative Cost factors for ICD codes
Comments: To: "Khan, Muhammad Z." <MKhan@OXHP.COM>
Content-Type: text/plain; charset="iso-8859-1"

Muhammad,

   First, we missed you at NESUG.  Other of your OXHP brethren were there,
why not you.  Dianne has already answered this, allow me to provide a few
more details.

Assume you have a table called FACTORS which has two columns:  ICD9 and
FACTOR.  Create a user-defined format as follows.

data cntlin;
  retain fmtname 'factor' type 'C';
  set FACTORS end = lastrec;
  start = ICD9;
  label = factor;
  output;
  if lastrec then do;
    hlo = 'O';
    label = 0;
    output;
  end;
  run;

proc format cntlin = cntlin; run;

Next run a data step to find the max factor:

data result;
  set medmart.claims;
  length f1 f2 f3 8;
  f1 = put( icd91, $factor. );
  f2 = put( icd92, $factor. );
  f3 = put( icd93, $factor. );
  maxFactor = max( f1, f2, f3 );
  run;

--
Jack N Shoemaker / JShoemaker@Accordant.net
Visit our patient communities at http://www.accordant.com or our corporate
site http://www.accordant.net


-----Original Message-----
From: Khan, Muhammad Z. [mailto:MKhan@OXHP.COM]
Sent: Friday, September 29, 2000 10:21 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Relative Cost factors for ICD codes


Hi Everyone,
        I have a list of relative cost factors that I need to apply to ICD9
codes (ICD1, ICD2  and ICD3 ).  Here is the problem.  I pulled all the ICD9
codes, now I want to apply the highest Cost factor to the ICD9 code.

Example:

If a member has an ICD1 code 011 the relative factor for this code is 26.39,
now if the same member has the ICD2 141 the relative factor is 41.92 and if
the ICD3 is 042 the factor becomes 60.97.  I need to apply the highest
factor to this member, in this case 60.97 regardless of ICD1, ICD2  or ICD3.
I have more than 100 ICD9 codes and relative factors associated with it.
Also, there are some ICD codes that are listed as 011, but I need to apply
the factors to all the codes that falls into 011 code range, such as 011.01,
011.02, 011.03 e.t.c.  I would appreciate any help on getting me started on
this problem.


TIA

Muhammad Khan

mkhan@oxhp.com