Date:         Mon, 22 Jan 2007 13:57:59 +0000
Reply-To:     toby dunn <tobydunn@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         toby dunn <tobydunn@HOTMAIL.COM>
Subject:      Re: Mixed data
Comments: To: Madan.Kundu@RANBAXY.COM
In-Reply-To:  <77943F39FD8BFB459C22A7A2E578626A05461C3A@NCORP-MSG-CLS.Ranbaxy.com>
Content-Type: text/plain; format=flowed

data ABC;
input id value $;
cards;
1 8.5
2 6.9
3 Neg
4 3.1
5 pos
6 neg
7 12.9
8 10
;
run;


Data Need ;
Set ABC ;
Where AnyAlpha( Value ) = 0 ;
Run ;

Proc Print
Data = Need ;
Run ;


Toby Dunn

To sensible men, every day is a day of reckoning. ~John W. Gardner

The important thing is this: To be able at any moment to sacrifice that
which we are for what we could become. ~Charles DuBois

Don't get your knickers in a knot. Nothing is solved and it just makes you
walk funny. ~Kathryn Carpenter






From: Madan Gopal Kundu <Madan.Kundu@RANBAXY.COM>
Reply-To: Madan Gopal Kundu <Madan.Kundu@RANBAXY.COM>
To: SAS-L@LISTSERV.UGA.EDU
Subject: Mixed data
Date: Mon, 22 Jan 2007 19:06:16 +0530

Dear All,

I have the following dataset ABC.

data ABC;
input id value $;
cards;
1 8.5
2 6.9
3 Neg
4 3.1
5 pos
6 neg
7 12.9
8 10
;
run;

From this dataset I want to get only the numeric values. My desired
dataset will contain only numeric values as follows:

Id      value
1       8.5
4       3.1
7       12.9
8       10

Kindly suggest me how I can achieve this in SAS.

Thanks in advance.
With best regards
MADAN

(i) The information contained in this e-mail message is intended only for
the confidential use of the recipient(s) named above. This message is
privileged and confidential. If the reader of this message is not the
intended recipient or an agent responsible for delivering it to the intended
recipient, you are hereby notified that you have received this document in
error and that any review, dissemination, distribution, or copying of this
message is strictly prohibited. If you have received this communication in
error, please notify us immediately by e-mail, and delete the original
message.


  (ii) The sender confirms that Ranbaxy shall not be responsible if this
email message is used for any indecent, unsolicited or illegal purposes,
which are in violation of any existing laws and the same shall solely be the
responsibility of the sender and that Ranbaxy shall at all times be
indemnified of any civil and/ or criminal liabilities or consequences there.

_________________________________________________________________
Type your favorite song.  Get a customized station.  Try MSN Radio powered
by Pandora. http://radio.msn.com/?icid=T002MSN03A07001