DATA Step, Macro, Functions and more

function that to separate between numbers and laters

Reply
SAS Employee
Posts: 105

function that to separate between numbers and laters

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 ??
SAS Employee
Posts: 174

Re: function that to separate between numbers and laters

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
Respected Advisor
Posts: 4,173

Re: function that to separate between numbers and laters

Posted in reply to GertNissen
just to add to the list:
- compress() using appropriate modifiers
- regular expressions like prxmatch() and prxsubstr()
- index(), indexc(), indexw()
- find() and findc()
Super Contributor
Posts: 673

Re: function that to separate between numbers and laters

data test;
var='abc efg 13';
var1=compress(var,,'a');
run;
SAS Employee
Posts: 105

Re: function that to separate between numbers and laters

Thanks alot ,got it !
Ask a Question
Discussion stats
  • 4 replies
  • 123 views
  • 0 likes
  • 4 in conversation