sorting a table box of a report by column, is it scriptable?

ron_horne

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 )

          );

ms

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.