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
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
if not anyalpha(name) then name='OTHER';
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.
On Thu, May 14, 2009 at 7:29 PM, saurabh <firstname.lastname@example.org> wrote:
> Hello All,
> I have a dataset , and its has a column called Name - Type Text.
> This column has the following values
> What I wish is to change all those name which are numeric to a value =
> help needed.