in any table box in an output it is possible to right-click and ask JMP to "sort by column". yet, re-ruing the saved script does not re-produce the sorted table. does anyone know a way to force the sorting?
for example, the following script will produce a pairwise correlation. i would like to sort it ascending by correlation.
dt = Open( "$ENGLISH_SAMPLE_DATA/Solubility.jmp");
obj = Multivariate(
Y( :Ether, :Chloroform, :Benzene, :Carbon Tetrachloride, :Hexane ),
Estimation Method( "Row-wise" ),
Scatterplot Matrix( 0 ),
Correlations Multivariate( 0 ),
Pairwise Correlations( 1 )
);
It seems as "Sort by column..." cannot be invoked by JSL in JMP 9 (see this thread: http://communities.sas.com/message/115929).
In principle, a tablebox can made into a data table, sorted and than appended to the report. However, the last step is not trivial if one want the the plotcolbox sorted. I hope that JMP 10 – coming tomorrow! – will make this command to work in JSL.
It seems as "Sort by column..." cannot be invoked by JSL in JMP 9 (see this thread: http://communities.sas.com/message/115929).
In principle, a tablebox can made into a data table, sorted and than appended to the report. However, the last step is not trivial if one want the the plotcolbox sorted. I hope that JMP 10 – coming tomorrow! – will make this command to work in JSL.