|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," "),