Date: Tue, 15 Sep 2009 06:51:09 -0700
Reply-To: RolandRB <rolandberry@HOTMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: RolandRB <rolandberry@HOTMAIL.COM>
Subject: Re: Finding first numeric in a text and taking into another
Content-Type: text/plain; charset=ISO-8859-1
On 15 Sep., 08:38, shashi <shashi2...@gmail.com> wrote:
> Finding first numeric in a text and taking into another column:
> Can anybody suggest how to find the first numeric of a column and
> taking into another column?
> The text looks like:
> First numerics in the above text column should be taken into another
> column like:
> Any help will be much appreciated.
This is converting it into a sas numeric.
num=input(scan(translate(str," ",compress(str,"0123456789")),1," "),