BookmarkSubscribeRSS Feed
Choose Language Hide Translation Bar

Community Trekker

Joined:

May 6, 2013

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

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

Community Trekker

Joined:

Jun 29, 2012

Solution

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

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 2

Community Trekker

Joined:

Jun 29, 2012

Solution

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

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.

Community Trekker

Joined:

May 6, 2013

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

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.