Date:         Thu, 14 May 2009 20:39:41 -0500
Reply-To:     Joe Matise <snoopy369@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Joe Matise <snoopy369@GMAIL.COM>
Subject:      Re: Text Manipulation
Comments: To: saurabh <saurabhkdas@gmail.com>
In-Reply-To:  <097a11a3-f189-4715-987f-d9a028cf2ba3@j9g2000prh.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1

Ya's solution is a simple one.  You could also use either the ANYALPHA or
the ANYDIGIT function to identify strings that contain no alphabetic
characters:

if not anyalpha(name) then name='OTHER';

or
if anydigit(name) ...

depending on if you want it to only return OTHER if all chars are not
alphabetic characters, or if one of the characters is a digit.

-Joe

On Thu, May 14, 2009 at 7:29 PM, saurabh <saurabhkdas@gmail.com> wrote:

> Hello All,
>
> I have a dataset , and its has a column called Name - Type Text.
>
> This column has the following values
> Name
> ---------
> John
> Jones
> 5648
> Paul
> 78900
> Julie
> ...
> ...
> ...
>
>
>
> What I wish is to change all those name which are numeric to a value =
> "Others".
>
> help needed.
>
> thanks
> SD
>