Subscribe Bookmark RSS Feed

JSL: Row states assignment

vishwasanj

Contributor

Joined:

Dec 27, 2016

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

2 ACCEPTED SOLUTIONS

Accepted Solutions
txnelson

Super User

Joined:

Jun 22, 2012

Solution

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;
Jim
Craige_Hales

Staff

Joined:

Mar 21, 2013

Solution

 

 

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 markersData table with row states set to random colors and markers

 

Craige
2 REPLIES
txnelson

Super User

Joined:

Jun 22, 2012

Solution

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;
Jim
Craige_Hales

Staff

Joined:

Mar 21, 2013

Solution

 

 

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 markersData table with row states set to random colors and markers

 

Craige