topic Re: JSL: Row states assignment in Discussions

JSL: Row states assignment

vishwasanj — Wed, 25 Jan 2017 22:17:50 GMT

I am still new to the row state idea and implementation.

Can anyone tell me the syntax for selecting the first 50 rows of a data table and applying radom markers(preferably variety of markers and colors) and colors as row states ?

I really appreciate it. Thank you

Re: JSL: Row states assignment

txnelson — Thu, 26 Jan 2017 00:33:14 GMT

Here is a sample script working on the Big Class sample data table. I think it will give you an idea on how to do what you asked

names default to here(1);
dt=open("$SAMPLE_DATA/big class.jmp");

// To color the first 20 rows, the rows outside of that
// limit need to be excluded from the coloring
dt << select where(Row()>20);
dt << hide and exclude(1);

dt << color or mark by column("sex", marker theme(hollow));
dt << color or mark by column("age");
dt << hide and exclude(0);
dt << clear select;

Re: JSL: Row states assignment

Craige_Hales — Thu, 26 Jan 2017 20:43:48 GMT

dt = Open( "$sample_data/big class.jmp" );
// http://www.jmp.com/support/help/Row_State_Functions.shtml
dt << setrowstates(
	J( N Rows( dt ), 1/*cols*/,  
		Random Integer( 0, 15 ) * 16 // marker bits 4-7
		+ Random Integer( 0, 127 ) * 256 // color bits 8-14
	)
);

Data table with row states set to random colors and markers