topic how to best verify if a field contains the good characters? in SAS Procedures

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

Pontch — Tue, 14 Feb 2012 18:32:25 GMT

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 — Tue, 14 Feb 2012 18:35:44 GMT

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

Haikuo — Tue, 14 Feb 2012 18:43:59 GMT

Add a few,

And of course compress() plus lengthn().

Regards,

Haikuo