JSL for using a column group in a formula

PNash — Mon, 22 Oct 2018 18:14:15 GMT

Hi;

New to JMP / JSL. I'm trying to add a formula column at the end of a set of data that calculates the STD DEV of the column data. The header data will be variable, so I need a generic assignment of column numbers.

My script is obviously wrong, otherwise I wouldn't be here but this is what I was trying;

dt << Group Columns ("Weeks", Column (2), 26);
dt << New Column ("STDEV", Characteristic, Formula (std dev("Weeks")));

Any guidance is appreciated! Thanks!

-Phil

Re: JSL for using a column group in a formula

PNash — Mon, 22 Oct 2018 18:14:52 GMT

Nevemind, figured it out!

dt << Group Columns ("Weeks", Column (2), 26);
colgrp = dt << get column group("Weeks");
dt << New Column ("STDEV", Numeric, Formula (std dev(colgrp)));

topic Re: JSL for using a column group in a formula in Discussions

JSL for using a column group in a formula

Re: JSL for using a column group in a formula