cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Register for our Discovery Summit 2024 conference, Oct. 21-24, where you’ll learn, connect, and be inspired.
Choose Language Hide Translation Bar
shampton82
Level VII

Get the title from a number col box

Okay so just starting to dive into Tree navigation and I have this simple script that I'm experimenting with:

names default to here(1);

dt=current data table();

//this is a partition analysis
actobj=Current Report()[outlinebox(1)]<<get scriptable object;

actobjrpt=actobj<<report;

//this links to the Logworth value from the first split
actobjtable = actobjrpt[numbercolbox( 7 )][1];

So I can get the value of the Logworth but I also want to get the title from the numbercolbox which is "Logworth".  So far I can't figure it out.  Thanks for any suggestions!

 

Steve

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: Get the title from a number col box

Here is one way to get what you want

names default to here(1);

// Open Data Table: big class.jmp
// → Data Table( "big class" )
dt = Open( "/C:/Program Files/SAS/JMPPRO/14/Samples/Data/big class.jmp" );

Partition(
	Y( :height ),
	X( :age, :sex, :weight ),
	Informative Missing( 1 ),
	Initial Splits( :weight < 81, {}, {:age == {12, 13}} ),
	SendToReport(
		Dispatch( {}, "Partition Report", FrameBox, {Frame Size( 480, 62 )} )
	)
);

//this is a partition analysis
actobjrpt=Current Report();

actobjrpt=actobj<<report;

//this links to the Logworth value from the first split
actobjtable = (actobjrpt[numbercolbox( 7 )]<<get)[1];

// get the header
theHeader = actobjtable = actobjrpt[numbercolbox( 7 )]<<get heading;

show(actobjtable, theHeader);
Jim

View solution in original post

3 REPLIES 3
txnelson
Super User

Re: Get the title from a number col box

Here is one way to get what you want

names default to here(1);

// Open Data Table: big class.jmp
// → Data Table( "big class" )
dt = Open( "/C:/Program Files/SAS/JMPPRO/14/Samples/Data/big class.jmp" );

Partition(
	Y( :height ),
	X( :age, :sex, :weight ),
	Informative Missing( 1 ),
	Initial Splits( :weight < 81, {}, {:age == {12, 13}} ),
	SendToReport(
		Dispatch( {}, "Partition Report", FrameBox, {Frame Size( 480, 62 )} )
	)
);

//this is a partition analysis
actobjrpt=Current Report();

actobjrpt=actobj<<report;

//this links to the Logworth value from the first split
actobjtable = (actobjrpt[numbercolbox( 7 )]<<get)[1];

// get the header
theHeader = actobjtable = actobjrpt[numbercolbox( 7 )]<<get heading;

show(actobjtable, theHeader);
Jim
shampton82
Level VII

Re: Get the title from a number col box

I was so close! I tried "Get" and "Get Title" then gave up and came here as there are a million get commands.

 

Thanks for the quick rely!

 

Steve 

Craige_Hales
Super User

Re: Get the title from a number col box

see if the <<GetHeading message is the one you need.

Scripting index example for Get Heading.Scripting index example for Get Heading.

Craige