Finding numbers in Charecter
in [SAS]
|
Prev: Enterprise Guide: Clear/ Export project log automatically
Next: Creating a matrix from a vector (using arrays)
From: Raj on 27 Apr 2010 05:47 Hi, I have 10 length charecter column which has numeric also. for exmaple: LT100124 009552319924 my requirement is if the value has only 0-9 like 009552319924 then i need to write to output file and convert to numeric else leave them. could you please help me how to do that. Regards, raj
From: nina on 27 Apr 2010 08:46 data _null_; input _str_ $20. ; new_str_ = compress(_str_,,'kd'); put(_all_)(/=); datalines; LT100124 009552319924 ;;;; run;
From: Arthur Tabachneck on 27 Apr 2010 09:47 Raj, If I understand your question correctly then you might be able to use something like: data have; input old $20.; cards; LT100124 009552319924 ; data want; set have; if length(old) eq length(compress(old,,'kd')) then new=input(old,best12.); run; HTH, Art --------- On Apr 27, 5:47 am, Raj <rajiv...(a)gmail.com> wrote: > Hi, > > I have 10 length charecter column which has numeric also. > > for exmaple: > > LT100124 > 009552319924 > > my requirement is if the value has only 0-9 like 009552319924 then i > need to write to output file and convert to numeric else leave them. > > could you please help me how to do that. > > Regards, > raj
From: Nat Wooding on 27 Apr 2010 10:51 As I read the post, Raj wants one file with the numbers and the other with the strings. For fun, I found a different way to test whether there were characters in the original variable. Nat Wooding data have; input old $20.; cards; LT100124 009552319924 ; Data Char (drop = num ) Numeric; set have; if upcase( old ) ne Lowcase ( old) then do; * we have characters in the string; output char; return; end; Num = input( old , best. ); output numeric; run; ----- Original Message ----- From: "Arthur Tabachneck" <art297(a)NETSCAPE.NET> To: <SAS-L(a)LISTSERV.UGA.EDU> Sent: Tuesday, April 27, 2010 9:47 AM Subject: Re: Finding numbers in Charecter > Raj, > > If I understand your question correctly then you might be able to use > something like: > > data have; > input old $20.; > cards; > LT100124 > 009552319924 > ; > > data want; > set have; > if length(old) eq length(compress(old,,'kd')) then > new=input(old,best12.); > run; > > HTH, > Art > --------- > On Apr 27, 5:47 am, Raj <rajiv...(a)gmail.com> wrote: >> Hi, >> >> I have 10 length charecter column which has numeric also. >> >> for exmaple: >> >> LT100124 >> 009552319924 >> >> my requirement is if the value has only 0-9 like 009552319924 then i >> need to write to output file and convert to numeric else leave them. >> >> could you please help me how to do that. >> >> Regards, >> raj
From: Steve James on 27 Apr 2010 14:52
On Apr 27, 5:47 am, Raj <rajiv...(a)gmail.com> wrote: > Hi, > > I have 10 length charecter column which has numeric also. > > for exmaple: > > LT100124 > 009552319924 > > my requirement is if the value has only 0-9 like 009552319924 then i > need to write to output file and convert to numeric else leave them. > > could you please help me how to do that. > > Regards, > raj Use the ANYALPHA function. if anyalpha(string) ne 0 then put "string has characters' ; else put 'string has no characters' ; steve |