Date:         Mon, 27 Sep 2010 06:06:09 -0400
Reply-To:     "Ravinder.Maramamula" <ravinsun@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Ravinder.Maramamula" <ravinsun@GMAIL.COM>
Subject:      Character and Alphanumeric values
Content-Type: text/plain; charset=ISO-8859-1

Hi list,


I have a dataset and it contains a character variable which
has mixture of values like character and alphanumeric.
I want to validate the dataset and remove all the alphanumeric
values and place it in another dataset.

data have ;
infile datalines;
input var;
datalines;
aa
ab
abc
abcde
....
...
abcdefghijklmnopqrstuvwxyz
a23
b1
ab2
;
dataset want:
aa
ab
abc
abcde
.....
.....
abcdefghijklmnopqrstuvwxyz
;
Do we have any informat which would directly read telephone numbers of type
(987)6543210 as 9876543210.

Thanks in advance for your time.

Regards,
Ravi