With JSL what is the correct syntax to set the Column property "Reverse"

ALopez

Hi,

I need to set the properties of a Column to 1) Row Order levels and 2) Reverse.
So far I can do the first one without any problems.

 dt:ColXYZ <<Set Property ( "Row Order Levels", 1 );

However I cannot find anywhere what is the correct syntax to emulate the GUI button "Reverse"

 

I have tried several ways but none have worked.

 

 

 

David_Burnham

Just to be clear, are you talking about Row Order Levels, or Value Ordering?

 

Row Order Levels I think just takes a flag - your screenshot looks more like value ordering, and that takes a list e.g. 

 

<< Set Property( "Value Ordering", {"F", "M"} ),

Those buttons on the GUI are just utility buttons to help you create the order of the list.  They are not implemented as parameters in the message itself.  For the message you have to explicitly define the list, and ordering of the items defines the value ordering.

 

If you wanted to mimic the reverse logic, you need to do two things; first get a list of the unique values in the column:

 

dt = open("$SAMPLE_DATA/Big Class.jmp");
summarize(levels=by(dt:sex));
show(levels);

In this example:

 

levels = {"F", "M"};

And to reverse them:

 

reverseInto(levels);
show(levels);

This gives

levels = {"M", "F"};

So now you can write

dt:sex << setProperty("Value Ordering",levels);

Unless of course you really did mean Row Order Levels!