topic Re: function that to separate between numbers and laters in SAS Programming

function that to separate between numbers and laters

yonib — Mon, 12 Oct 2009 09:53:35 GMT

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 ??

Re: function that to separate between numbers and laters

GertNissen — Mon, 12 Oct 2009 10:46:42 GMT

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

Re: function that to separate between numbers and laters

Patrick — Mon, 12 Oct 2009 12:57:39 GMT

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

Re: function that to separate between numbers and laters

SASPhile — Mon, 12 Oct 2009 14:37:17 GMT

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

Re: function that to separate between numbers and laters

yonib — Tue, 13 Oct 2009 07:37:50 GMT

Thanks alot ,got it !