| Date: | Wed, 29 Jul 2009 08:10:56 -0700 |
| Reply-To: | inason <iharun17@GOOGLEMAIL.COM> |
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
| From: | inason <iharun17@GOOGLEMAIL.COM> |
| Organization: | http://groups.google.com |
| Subject: | Re: removing numeric values |
|
| Content-Type: | text/plain; charset=ISO-8859-1 |
On Jul 29, 3:43 pm, shruthi <pramila.s...@gmail.com> wrote:
> Hi
>
> I have a variable which is a character but also has occasional numeric
> values. I want to set the numeric values to missing. How can I do
> this ?
>
> A B
> 1 NORMAL
> 2 NORMAL
> 3 NORMAL
> 4 123
> 5 NORMAL
>
> I WANT:
> A B
> 1 Normal
> 2 NORMAL
> 3 NORMAL
> 4 .
> 5 NORMAL
try this
if not anydigit(b);
or
if anyalpha(b)
|