function that to separate between numbers and laters

[yonib]

Hi ,
I have data with vat that contains both numbers and laters.
For example : abc efgh 13 .
Is There a function that can separate between numbers and laters ??

[GertNissen]

You have many function you can use depending on what you want.

Have a look at
- ANYALNUM http://support.sas.com/onlinedoc/913/getDoc/en/lrdict.hlp/a002194054.htm or the other ANY... functions
- NOTALNUM http://support.sas.com/onlinedoc/913/getDoc/en/lrdict.hlp/a002194056.htm or the other NOT... functions
- VERIFY Function http://support.sas.com/onlinedoc/913/getDoc/en/lrdict.hlp/a000245970.htm
- SCAN Function http://support.sas.com/onlinedoc/913/getDoc/en/lrdict.hlp/a000214639.htm

[Patrick]

just to add to the list:
- compress() using appropriate modifiers
- regular expressions like prxmatch() and prxsubstr()
- index(), indexc(), indexw()
- find() and findc()

[SASPhile]

data test;
var='abc efg 13';
var1=compress(var,,'a');
run;

[yonib]

Thanks alot ,got it !