Question about how to use fit object for prediction in JSL

[#1]

Hi - I have 2 columns X and Y. I am using the Neural platform to fit Y with X, because it is quite non-linear. Now, I want to use the fitted model to predict Y for a given X. How do I accomplish this in JSL?

I have the following code:

obj = dt << Neural(
Y( :Vg ),
X( :Id ),
Informative Missing( 0 ),
Validation Method( "Holdback", 0.3333 )
);

After I have done the fit, I need to use this fit object to predict Y for certain values of X in another table. But, I am not sure how I can write JSL for that. Thanks in advance!

[#2 · Accepted solution]

From the neural platform you can save the formula to your table

jthi_0-1708977045434.png

and move it (or all of them, depending on your model) to other table if both have similarly named columns. Below is one example script

Names Default To Here(1); 

dt = open("$SAMPLE_DATA/Big Class.jmp");

nn = dt << Neural(
	Y(:sex),
	X(:height, :weight),
	Informative Missing(0),
	Validation Method("Holdback", 0.3333),
	Fit(NTanH(3))
);

cur_cols = dt << Get Column Names("String");
nn << (Fit[1] << Save Profile Formulas);
new_cols = dt << Get Column Names("String");

Remove From(new_cols, 1, N Items(cur_cols));

dt2 = Open("$SAMPLE_DATA/Big Class Families.jmp");

For Each({colname}, new_cols,
	colscript = Column(dt, colname) << get script;
	Eval(EvalExpr(
		Send(dt2, Expr(colscript));
	));
);

If you have JMP Pro you can also use Formula Depot which makes this maybe a bit easier.

[#3]

Hi - thanks a lot for providing the example script. Could you explain how I can modify if my column name in the other table is different? Also, could you please clarify how the JSL will change if I have Formula Depot? Thanks again!