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 2004, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Wed, 21 Jul 2004 15:46:49 -0400
Reply-To:     harry.droogendyk@RBC.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Harry Droogendyk <harry.droogendyk@RBC.COM>
Subject:      Re: aarumugam@stthomas.edu
Content-Type: text/plain; charset=iso-8859-1

Something like this?

data tab1; x = '23452345 ';output; x = '12345263'; output; x = '1234523A'; output; x = 'aasdfasd'; output; x = ' ' ; output; run;

proc print data=tab1; where n(input(trim(x),? 12.)); run;

-----Original Message----- From: An Am [mailto:aarumugam@STTHOMAS.EDU] Sent: Wednesday, July 21, 2004 3:28 PM To: SAS-L@LISTSERV.UGA.EDU Subject: aarumugam@stthomas.edu

I have a table tab1 and column name as x. Column x has alpha-numeric , numbers, characters values. I want to select only numeric values and want to avoid alpha-numeric and character values. Help please. Thanks, AN

------------------------------------------------------------This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized. If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately.

Ce courrier électronique est confidentiel et protégé. L'expéditeur ne renonce pas aux droits et obligations qui s'y rapportent. Toute diffusion, utilisation ou copie de ce message ou des renseignements qu'il contient par une personne autre que le (les) destinataire(s) désigné(s) est interdite. Si vous recevez ce courrier électronique par erreur, veuillez m'en aviser immédiatement, par retour de courrier électronique ou par un autre moyen.

============================================================


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