Choose Language Hide Translation Bar
Highlighted
shaira
Level IV

In Fit Model, how to Output Grid Table as "Invisible" and store it in a variable

Using the fit model function of JMP, we can output predicted values while fixing the value of another column. The script I use is below:

obj=Fit Model(
			Y(:Name( "OutVar1" ), :Name( "OutVar2" ), :Name( "OutVar3" ))
			Effects( :Name( "NormVar1" ) ),
			Personality( Standard Least Squares ),
			Emphasis( Minimal Report ),
			By(:Name( "GrpVar1" ), :Name( "GrpVar2" )),
			Run
	);
obj2=obj<<Profiler(1, Confidence Intervals( 1 ),
		   Term Value(Name( "NormVar1" )(62, Lock( 1 ), Show( 1 ))),
		   Output Grid Table
		   );

 

Hm, my question is how to I make the table from "Output Grid Table" command as invisible? I also want to store this table in a variable.

I tried this but it didn't work. Not even a table was generated,

obj2=obj<<Profiler(1, Confidence Intervals( 1 ),
		   Term Value(Name( "NormVar1" )(62, Lock( 1 ), Show( 1 )))
		   );
obj3=obj2 << Output Grid Table;

 Any ideas? Thanks.

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
txnelson
Super User

Re: In Fit Model, how to Output Grid Table as "Invisible" and store it in a variable

The script below will make the data table invisible, and attach a handle to the table.  It isn't as smooth as it should be.  I suggest you pass this to 

     support@jmp.com

as an enhancement request.  There really should be syntax within the profiler to permit this directly.

obj=Fit Model(
			Y(:Name( "OutVar1" ), :Name( "OutVar2" ), :Name( "OutVar3" ))
			Effects( :Name( "NormVar1" ) ),
			Personality( Standard Least Squares ),
			Emphasis( Minimal Report ),
			By(:Name( "GrpVar1" ), :Name( "GrpVar2" )),
			Run
	);
obj2=obj<<Profiler(1, Confidence Intervals( 1 ),
		   Term Value(Name( "NormVar1" )(62, Lock( 1 ), Show( 1 ))),
		   Output Grid Table
		   );
current data table()<< show window(0);
gridDT=current data table()
Jim

View solution in original post

Highlighted
shaira
Level IV

Re: In Fit Model, how to Output Grid Table as "Invisible" and store it in a variable

Hi @txnelson,

Thanks for the code. This is very helpful. I find it weird though that the script

Current Data Table()<<Show Window(0);

 does not work in itself. Instead, I have to do this:

 

Show(Current Data Table()<<Get Name());
Current Data Table()<<Show Window(0);

Nevertheless, the current script is now working. Thanks again for the help.

 

Shaira

View solution in original post

2 REPLIES 2
Highlighted
txnelson
Super User

Re: In Fit Model, how to Output Grid Table as "Invisible" and store it in a variable

The script below will make the data table invisible, and attach a handle to the table.  It isn't as smooth as it should be.  I suggest you pass this to 

     support@jmp.com

as an enhancement request.  There really should be syntax within the profiler to permit this directly.

obj=Fit Model(
			Y(:Name( "OutVar1" ), :Name( "OutVar2" ), :Name( "OutVar3" ))
			Effects( :Name( "NormVar1" ) ),
			Personality( Standard Least Squares ),
			Emphasis( Minimal Report ),
			By(:Name( "GrpVar1" ), :Name( "GrpVar2" )),
			Run
	);
obj2=obj<<Profiler(1, Confidence Intervals( 1 ),
		   Term Value(Name( "NormVar1" )(62, Lock( 1 ), Show( 1 ))),
		   Output Grid Table
		   );
current data table()<< show window(0);
gridDT=current data table()
Jim

View solution in original post

Highlighted
shaira
Level IV

Re: In Fit Model, how to Output Grid Table as "Invisible" and store it in a variable

Hi @txnelson,

Thanks for the code. This is very helpful. I find it weird though that the script

Current Data Table()<<Show Window(0);

 does not work in itself. Instead, I have to do this:

 

Show(Current Data Table()<<Get Name());
Current Data Table()<<Show Window(0);

Nevertheless, the current script is now working. Thanks again for the help.

 

Shaira

View solution in original post

Article Labels

    There are no labels assigned to this post.