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
