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