nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

script "Save Coefficients"?

unknown

Sorry for the newbie question - I have a heavy programming background but new to JMP/JSL and trying to solve a problem for JMP users in my group.

They created a bivariate spline curve fit that works fine:

Bivariate(
Y( :K_102_2040537_1 ),
X( :Week ),
Fit Spline( 0.6, {Line Color( "Red" ), Line Style( Smooth )} )
)

The challenge is that they need to run this for thousands of items (the Y axis) and save the coefficients. I quickly found in the documentation how to iterate through all the items and generate the reports, but the only way I can find to get the coefficients is to manually select the dropdown list on each report and select "Save Coefficients," which then opens another data table.

How can I get that data table of coefficients by a script without having to manually select it from the report?
Thanks!

Accepted answers

All comments

mpb

Here are a couple of ways:

First Way

unknown

Brilliant! Thanks.

I'll post my final script when completed for edification.

unknown

Here's what I came up with - probably could be improved, but needed to get it done quickly and learned just enough JSL to get it done. The production version of this is analyzing thousands of columns rather than the 2 sample columns in this test version. It saves the results of each iteration to a database table. Thanks for the help, and constructive criticism welcome.

mpb

Very nice. I assume that you and your colleague are comfortable using the same smoothing parameter value (lambda=100) for thousands of bivariate spline fits?