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

[#1]

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. 

[#2 · Accepted solution]

You need to properly reference the column 

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

or

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

[#3]

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);