topic Script to save prediction formula of PLS in Discussions

Script to save prediction formula of PLS

rummeln — Fri, 09 Jun 2023 17:06:19 GMT

Hello,

I'm using a script to run PLS on my data, but I'm having a hard time getting it to save the prediction formula & values into a column in the data sheet. Is this possible? Here's what I'm using so far:

Names Default To Here( 1 );
<
P = Partial Least Squares(
	Y( :Viability ),
	X( :Name( "976" ), :Name( "778" ), :Name( "973" ), ),
	Validation Method( None, Initial Number of Factors( 15 ) ),
	Fit( Method( NIPALS ), Number of Factors( 15 ) ), 

);
P << prediction formula;
>

Thanks

Re: Script to save prediction formula of PLS

txnelson — Tue, 02 Aug 2022 00:54:34 GMT

Here is the example from the Scripting Index that shows how to Save Prediction Formula

And here is an example using a slight modification to your code, and using the Semiconductor Capability sample data table

Names Default To Here( 1 );
dt =
// Open Data Table: semiconductor capability.jmp
// → Data Table( "semiconductor capability" )
Open( "$SAMPLE_DATA/semiconductor capability.jmp" );

P = Partial Least Squares(
	Y( :PNP1 ),
	X( :Name( "NPN1" ), :Name( "NPN2" ), :Name( "NPN3" ), ),
	Validation Method( None, Initial Number of Factors( 15 ) ),
	Fit( Method( NIPALS ), Number of Factors( 15 ) ), 

);
P << obj << (Fit[1] << Save Prediction Formula);

Re: Script to save prediction formula of PLS

rummeln — Tue, 02 Aug 2022 03:57:38 GMT

Worked like a charm, thanks Jim!

Re: Script to save prediction formula of PLS

hogi — Sun, 23 Oct 2022 09:29:42 GMT

Is there a function to get the prediction formula from a fit as JSL code - without saving it to a column or using a Formula Depot?

Something more robust than

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
myFit = dt << Fit Model( Y( :height ), Effects( :age, :sex ), Run() );
FormulaExpr=Arg(Arg(myFit << Get Prediction Formula,3))