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; } } }

Export model parameters

Mark_Zwald

I have a customer with a specific request to be able to generate a table of model parameters (ex. slopes from linear fit) grouped by some other column (ex. lot numbers). I know how to get the model parameters through the Fit Y by X platform grouped by lot number but not sure how to conventiently export all the individial fit parameters into a separate table. Example if there are 1000 lot numbers in data table, then desired table would have 1000 rows with lot, slope and intercept columns.

Any suggestions for this are welcome!

Thanks,

Mark Zwald

Accepted answers

brady_brady

dt = astable(J(200,2,randomuniform())||J(200,1,randominteger(5)));

biv = dt << Bivariate(x(:col1), y(:col2), by(:col3), <<fit line);

report(biv[1])[outlinebox("Parameter Estimates")][tablebox(1)]<<Make Combined Data Table

All comments

Peter_Hersh

Hey Mark,

If I am understanding this correct. Try right clicking on the fit statistics window and selecting make into combined data table.

Does that get what you are after?

Pete

MikeD_Anderson

There is a platform called “response screening” (or something like that) that does this for linear regression. I think it’s covered in the “fitting linear models” book under the help menu or wherever the other screening platforms are.

Best,

M
- From somewhere other than his desk.

Mark_Zwald

Very good, this works if the object is in a table format. The paramters from the Fit Y by X platform are not but the Fit Model platform will do this. Excellent suggestion!

Thanks,

Mark

Mark_Zwald

Thanks Mike, I'll like into the response screening platform some more but it wasn't immediately obvious how to get the desired output from it. This might provide a more scritable solution than what Peter suggested.

brady_brady

The parameter estimates section has the slope and intercept in table form. (Scroll down to the bottom of the report.)

Mark_Zwald

Thanks Brady, I see it.

Is there a way to script this solution? For example, right click on Fit Model parameter estimates and select 'make into combined data table'?