I loop over columns in a table collected from the DB. Some of them have no data in them (leading to empty charts). Is there a way to check if a column has numeric values?
Go to Solution
It seems that my version of JMP (11.1.1 x64) doesn't recognize the Anydigit function, however your answer led straigth to my answer:
ColMinValue = Col Minimum( :MyColumn );
Is Missing(ColMinValue) -> true if there is no value for ColMinValue.
View solution in original post
Anydigit(string), is 0 if doesn't contain digits, 1 if it does.
If you want to check if they are convertible to number then do:
if anyalpha(string)=0 then no upper or lower characters so assume number.
If you have special characters then compress them out.
attrib my_string format=$20.;
attrib my_num_var format=best.;
if have_convertible=0 then my_num_var=input(my_string,best.);