Date: Wed, 15 Aug 2007 19:29:43 +0000
Reply-To: toby dunn <tobydunn@HOTMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: toby dunn <tobydunn@HOTMAIL.COM>
Subject: Re: Help with SAS Character formats
Content-Type: text/plain; format=flowed
Id recommend you first do some studing up on ICD-9 codes. They arent
numerics, that '.0' your adding has meaning in ICD-9 world and not all
ICD-9's have a decimal and following numeric values(s).
In fact E903 is just that and no more there is no '.0', it is a Category,
E904 is a category while E904.0, E904.1, E904.2, E904.3, and E904.9 (notice
the gap between E904.3 and E904.9) these are subcategories of Cat E904 .
The way I do this is to use Perl RegEx specifically PrxChange, and create
another variable character variable to hold the value.
Two wrongs are only the beginning.
Success always occurs in private and failure in full view.
Experience is something you don't get until just after you need it.
From: Anil Anand <anilkranand@GMAIL.COM>
Reply-To: Anil Anand <anilkranand@GMAIL.COM>
Subject: Help with SAS Character formats
Date: Wed, 15 Aug 2007 15:18:08 -0400
I have a variable called 'PRINECDE' with the following sample values:
which have to be converted to
Once converted I will use Proc Format to get ranges for the PRINECDE
It is easy to convert a numeric value to a decimal format. Can someone show
me how to convert a character value to a decimal format.
Tease your brain--play Clink! Win cool prizes!