topic Re: How to find if a variable contains none numeric values? in SAS Enterprise Guide

How to find if a variable contains none numeric values?

Suzy_Cat — Tue, 19 Nov 2019 23:14:20 GMT

hi there,

I need identify if there is random non-numeric (may incl. Alphabet, symbols, etc.) value in a variable which is a text string.

is there a better way to do it?

data _null_;

set test;

j=0;

do until(j=0);

j=notdigit(Var,j+1);

if j=0 then put +3 "That's all";

else do;

c=substr(Var,j,1);

put +3 j= c=;

end;

run;

PaigeMiller — Tue, 19 Nov 2019 23:32:17 GMT

I don't think the looping is needed.

All you need is

if notdigit(var)>0 then ...   ;

Suzy_Cat — Wed, 20 Nov 2019 00:42:20 GMT

Hi Paige,

Thanks for your answer. I have tested and it worked 🙂 just not sure if it would pick up all the ones with random combination of symbols.

But it worked for my data.

Cheers