Date: Mon, 27 Sep 2010 21:38:14 +0530
Reply-To: "Ravinder.Maramamula" <ravinsun@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Ravinder.Maramamula" <ravinsun@GMAIL.COM>
Subject: Re: Character and Alphanumeric values
Content-Type: text/plain; charset=ISO-8859-1
Sorry for the confusion ,I want to remove all the patterns which are
associated with numbers.
so i want to remove all the below patterns and want to put in another
How can i achieve that ,any help in this aspect is well appreciated.
On Mon, Sep 27, 2010 at 9:18 PM, Gerhard Hellriegel <
> for me it is not fully clear what you want. You write, you want to remove
> all the alphanumeric data and place it in another dataset. Alphanumeric is
> ALL, numbers and characters! What do you want to remove? Your example
> seems to extract only records without any numeric part. The "want"
> dataset, is that the "other" - dataset, or that what remains after
> removing something. What is with data with any number-parts? Records
> I'm not aware of any informat for telephone numbers. Think there are no
> real standards for the numbers.
> With the compress-function you can remove anything what you don't want,
> including blanks, -, (, ), ....
> data a;
> x="(123) - 123456";
> y=compress(x,"(),.+- ");
> put x= / y=;
> On Mon, 27 Sep 2010 06:06:09 -0400, Ravinder.Maramamula
> <ravinsun@GMAIL.COM> wrote:
> >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;
> >dataset want:
> >Do we have any informat which would directly read telephone numbers of
> >(987)6543210 as 9876543210.
> >Thanks in advance for your time.
TOUGHT TIMES NEVER LAST!!!!!BUT TOUGH PEOPLE DO!!!!!