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

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!