Community Trekker

Joined:

Feb 21, 2014

## Check if a column has numeric data

Hi everyone,

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?

thx guys,

Jan

1 ACCEPTED SOLUTION

Accepted Solutions

Community Trekker

Joined:

Feb 21, 2014

Solution

## Re: Check if a column has numeric data

Thank you,

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.

Thx!!!

Jan

2 REPLIES

Community Trekker

Joined:

Apr 5, 2013

## Re: Check if a column has numeric data

Hi,

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.

E.g.:

data have;

attrib my_string format=\$20.;

my_string="12345"; output;

my_string="-12345"; output;

my_string="ABC12345"; output;

run;

data want;

set have;

attrib my_num_var format=best.;

have_any_digit=anydigit(my_string);

have_convertible=anyalpha(compress(my_string,"-+."));

if have_convertible=0 then my_num_var=input(my_string,best.);

run;

Community Trekker

Joined:

Feb 21, 2014

Solution

## Re: Check if a column has numeric data

Thank you,

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.

Thx!!!

Jan