topic Re: anyalpha function in SAS Procedures

anyalpha function

brophymj — Mon, 20 Jul 2015 11:09:46 GMT

My understanding is that this function returns a position of the first letter of the alphabet in a string. Is there a similar function that include all non-numeric symbols.

The code I'm using is if anyalpha(field1) eq 0 then field2 = field1;

else field2 = 0;

But I'm not sure what function I should use if there is "/", "-", etc.

Re: anyalpha function

brophymj — Mon, 20 Jul 2015 11:24:29 GMT

I actually googled it there and the function for non-alphabetical characters is notalpha

Re: anyalpha function

brophymj — Mon, 20 Jul 2015 11:30:29 GMT

actually that doesn't work. What I'm looking for is a function that returns the position of the first character in a string that is not a number.

Re: anyalpha function

RW9 — Mon, 20 Jul 2015 12:13:01 GMT

Have you tried:

position=findc(your_string,'_','a');

Note I just added _ to give it something to work with, the main part is the 'a' which adds all the alpha characters.

Re: anyalpha function

Ksharp — Mon, 20 Jul 2015 12:15:50 GMT

Check notdigit() function .