Subscribe Bookmark RSS Feed

Is it possible to automate building of 1000+ linear regression fit models and selectively saving based on p-value criteria using a script?

woongkim

Community Trekker

Joined:

May 6, 2013

Hi everyone.

I have a daunting task of finding out the best a linear mixed mixed model using 350+ variables. I know you could do a fit model with stepwise mode but JMP does not allow this function with random effect component. So we are currently building forward selecting the independent variables to build all possible combination of models semi-automatically using a loop function in the script. The downside is I have to manually sift through the reports and copy+paste the "Summary of Fit" and "Parameter Estimates" with the VIF information into an excel file.

My question is does JMP has script capability to selectively save the results of the report based on a condition that all p-values of each variable is less than 0.05? The overall construct would be based on 4 independent variables A, B, C and D and 1 dependent variables, Z would be random effect, E would be something like this;

Test E = A + Z(random)

     if all term p-value(s) is/are less than 0.05 --> save "Summary of Fit" and "Parameter Estimates" with the VIF column to Results File (excel or word file)

E = A + B+ Z(random)

if all term p-value(s) is/are less than 0.05 --> save "Summary of Fit" and "Parameter Estimates" with the VIF column to Results File (excel or word file)

E = A + C+ Z(random)

if all term p-value(s) is/are less than 0.05 --> save "Summary of Fit" and "Parameter Estimates" with the VIF column to Results File (excel or word file)

E = A + D+ Z(random)

if all term p-value(s) is/are less than 0.05 --> save "Summary of Fit" and "Parameter Estimates" with the VIF column to Results File (excel or word file)

E = B+ Z(random)

if all term p-value(s) is/are less than 0.05 --> save "Summary of Fit" and "Parameter Estimates" with the VIF column to Results File (excel or word file)

E = B + C+ Z(random)

if all term p-value(s) is/are less than 0.05 --> save "Summary of Fit" and "Parameter Estimates" with the VIF column to Results File (excel or word file)

E = B + D+ Z(random)

if all term p-value(s) is/are less than 0.05 --> save "Summary of Fit" and "Parameter Estimates" with the VIF column to Results File (excel or word file)

E = C+ Z(random)

if all term p-value(s) is/are less than 0.05 --> save "Summary of Fit" and "Parameter Estimates" with the VIF column to Results File (excel or word file)

E = C + D+ Z(random)

if all term p-value(s) is/are less than 0.05 --> save "Summary of Fit" and "Parameter Estimates" with the VIF column to Results File (excel or word file)

E = D+ Z(random)

if all term p-value(s) is/are less than 0.05 --> save "Summary of Fit" and "Parameter Estimates" with the VIF column to Results File (excel or word file)

end

Any lead on this problem would save me a lot of time and grief. Thank you in advance.

Woong

1 ACCEPTED SOLUTION

Accepted Solutions
Solution

This should be very doable. Here are some tips for getting started. Check out the Platform Example starting on p. 339 of the JMP 10 scripting guide. This goes through how to pull individual values out of a table in a report. Once you identify a hit you can use the "<<Make Into Data Table" command to capture the entire table.


2 REPLIES
Solution

This should be very doable. Here are some tips for getting started. Check out the Platform Example starting on p. 339 of the JMP 10 scripting guide. This goes through how to pull individual values out of a table in a report. Once you identify a hit you can use the "<<Make Into Data Table" command to capture the entire table.


woongkim

Community Trekker

Joined:

May 6, 2013

Thank you. The sections you mentioned seem to do exactly what I want to do. BTW the page number was p341 on the release 10 guide book.