cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Learn how to build custom Python data connectors and further customize JMP’s Data Connector Framework with the Python Data Connector Demo, available now in the JMP Marketplace!
  • See how to move from signal modeling to system modeling at the first JMP Aerospace Analytics webinar. Register. June 18, 1 p.m. US Eastern Time.

Discussions

Solve problems, and share tips and tricks with other JMP users.
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

Recommended Articles