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
Content-Type: text/plain; charset="iso-8859-1"
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
Assume you have a table called FACTORS which has two columns: ICD9 and
FACTOR. Create a user-defined format as follows.
retain fmtname 'factor' type 'C';
set FACTORS end = lastrec;
start = ICD9;
label = factor;
if lastrec then do;
hlo = 'O';
label = 0;
proc format cntlin = cntlin; run;
Next run a data step to find the max factor:
length f1 f2 f3 8;
f1 = put( icd91, $factor. );
f2 = put( icd92, $factor. );
f3 = put( icd93, $factor. );
maxFactor = max( f1, f2, f3 );
Jack N Shoemaker / JShoemaker@Accordant.net
Visit our patient communities at http://www.accordant.com or our corporate
From: Khan, Muhammad Z. [mailto:MKhan@OXHP.COM]
Sent: Friday, September 29, 2000 10:21 AM
Subject: Relative Cost factors for ICD codes
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.
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