JSL code for summary table creation

BackwardTiger97 — Thu, 08 Jun 2023 16:40:16 GMT

im creating a summary table from dt1 called dt2. Code below. does anyone know the code for statistics column name format? i need it to be column stat.

I think when its default is stat(column), it throws off the join.

dt2 = dt1 << Summary(
	Group(:lot),
	Mean(:x, :y, :z),
	Freq("None"),
	Weight("None"),
	Link to original data table(0),
	statistics column name format("column stat")
);


dt1 << Update(
	With(dt2),
	Match Columns(:lot = :lot, ),
	Add Columns from Update table(:Mean(x), :Mean(y), :Mean(z))
);

Thank you

Re: JSL code for summary table creation

jthi — Sat, 28 Jan 2023 18:53:11 GMT

I edited your message to add JSL formatting and fixed missing , (maybe the missing , was issue you were having?). Create summary with JMP and then copy the script from Source table script

Data Table("Big Class") << Summary(
	Mean(:height),
	Mean(:weight),
	Freq("None"),
	Weight("None"),
	statistics column name format("column stat")
)

topic JSL code for summary table creation in Discussions

JSL code for summary table creation

Re: JSL code for summary table creation