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
Comments: To: anilkranand@GMAIL.COM
In-Reply-To:  <69d823a40708151218gf90102q4d1ba31ff1e4c97d@mail.gmail.com>
Content-Type: text/plain; format=flowed

Anil ,

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.



Toby Dunn


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>
To: SAS-L@LISTSERV.UGA.EDU
Subject: Help with SAS Character formats
Date: Wed, 15 Aug 2007 15:18:08 -0400

Hello All,

I have a variable called 'PRINECDE' with the following sample values:

E8120
E8849
E8120
E903
E9203
E8120

which have to be converted to
E812.0
E884.9
E812.0
E903.0
E920.3
E812.0

Once converted I will use Proc Format to get ranges for the PRINECDE
variable.

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.

Thanks,

Anil

_________________________________________________________________
Tease your brain--play Clink! Win cool prizes!
http://club.live.com/clink.aspx?icid=clink_hotmailtextlink2