how to best verify if a field contains the good characters?

[Pontch]

Hi guys,

I am trying to check if a specific field contains only text characters.

I am using the following code to verify if the field country does not contain any numeric char:

verify(country,"ABCDEFGHIJKLM")>0

I wonder if there are better ways to achieve that objective.

Thanks for all your help in advance!

Cheers,

Tom

[art297 · Accepted solution]

You could use the notalpha function http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a002194058.htm

If it returns a non-zero value the field contains something other than alpha characters

[Haikuo]

Add a few,

ANYALPHA Function

ANYDIGIT Function

NOTALPHA Function

NOTDIGIT Function

And of course compress() plus lengthn().

Regards,

Haikuo