cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar

JSL code for summary table creation

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

1 REPLY 1
jthi
Super User

Re: JSL code for summary table creation

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

jthi_0-1674931904564.png

-Jarmo