topic Re: Getting a dot " . " as a result when computing Column Mean and Qunatile. in Discussions

Getting a dot " . " as a result when computing Column Mean and Qunatile.

RA899 — Tue, 21 Nov 2023 19:43:57 GMT

Hi,

I'm trying to get the column names from a table, save it, and then extract its properties. When I try to get the column mean or Quantile but the return is just a dot. No number is returned. The columns are returned as a list as shown below. The results are shown below too. Your

Your help is appreciated.

Re: Getting a dot " . " as a result when computing Column Mean and Qunatile.

txnelson — Tue, 21 Nov 2023 19:55:36 GMT

You need to properly reference the column

q_M=col mean( column(char(colnames[21])));

q_M=col mean( eval(colnames[21]));

Re: Getting a dot " . " as a result when computing Column Mean and Qunatile.

hogi — Tue, 21 Nov 2023 20:21:23 GMT

wow, Eval(colname) works here as well!

Alternatively, you could send the table the message get column references() to get column references which can be directly used in the code.

The only disadvantage: there is no option continuous to selectively pick the continuous ones.

The workaround: get column references() accepts a list of column names (or strings):

Names Default to Here(1);
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
	
AllcolNames = dt << get column references();
colNames = dt << get column references(dt << get column names(continuous));

Col Quantile(colNames[2], 0.95);