Date:         Mon, 18 Nov 2002 08:29:42 -0800
Reply-To:     shiling zhang <shiling99@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         shiling zhang <shiling99@YAHOO.COM>
Organization: http://groups.google.com/
Subject:      Re: Is a variable Numeric?
Content-Type: text/plain; charset=ISO-8859-1

I think it may be better to use SAS input function to test for
convertible strings. There are many forms of number representations in
SAS.



data _null_ badguys;
   x='123.56+';
   y=input(x, ? best.);
   if _error_=1 then output badguys;
 run;




"roland.rashleigh-berry" <roland.rashleigh-berry@ntlworld.com> wrote in message news:<Gl2C9.115$p_2.44298@newsfep1-win.server.ntli.net>...
> "גדי בן אבי" <GADI_B@MALAM.COM> wrote in message
> news:B3A415965C0CBC46AE5D76C9B90166AD215C96@jer-mailbox1.jer.ad.malam.com...
> Hi all,
>
> Q: How do I check if a variable is numeric?
>
> A: You can use the "vartype()" function.
>
> Q: How do I check if a text variable has numeric content (only digits, a
> period and a sign)?
>
> A: if compress(var,'0123456789.+-') EQ ' ' then...