LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (July 2009, week 5)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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
Comments:   To: sas-l@uga.edu
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)


Back to: Top of message | Previous page | Main SAS-L page