topic Re: Can I cross variables already added to a model (fit model)? in Discussions

Can I cross variables already added to a model (fit model)?

dacotton — Fri, 09 Jun 2023 00:18:01 GMT

I am hoping to use the macros (factorial to degree) cross on variables that have already been added to a model so that I don't have to find the columns from scratch (dealing with a very large data set) to be able to cross them. Any ideas? Also, I do not know much about programming.

Re: Can I cross variables already added to a model (fit model)?

Thierry_S — Thu, 02 Jul 2020 23:05:05 GMT

Hi,
This a functionality that most of us would love to have but it is not available, at least in JMP14.1.
One of the most efficient way to add interactions between variables in existing model is to:
1) run the model as-is
2) save the script: red top left triangle menu > Save script > To Script Window
3) In the Effects line of code, add the interactions you which to explore (make sure to use the exact syntax for variables as listed for the individual effects)
Example: :data1 * :data2, *:data1 * :data3....

Re: Can I cross variables already added to a model (fit model)?

dacotton — Thu, 02 Jul 2020 23:14:58 GMT

@Thierry_S

Alright, thank you! Hopefully, they add this feature soon!

Re: Can I cross variables already added to a model (fit model)?

Mark_Bailey — Fri, 03 Jul 2020 11:18:04 GMT

Perhaps this case would be easier if you first isolate the data columns with the variables for the modeling using Tables > Subset.

Re: Can I cross variables already added to a model (fit model)?

P_Bartell — Fri, 03 Jul 2020 14:25:25 GMT

Maybe I'm not fully and correctly understanding your request, but couldn't you use the Edit function within the Effect Summary Fit Model report window? Selecting 'Edit' brings up a new Fit Model dialogue box and from there you can use the usual Fit Model model building macros, transforms, etc. So you can articulate your interaction effects and hit the 'Commit' button and your model report window will automatically update according to the model selections you've made.

Hope this helps?

Re: Can I cross variables already added to a model (fit model)?

dacotton — Tue, 07 Jul 2020 15:24:48 GMT

@P_Bartell

Thank you for your reply. The trouble is that you have to re-select all the columns from the "select columns" box rather than being able to select them from the "effects" box once you are in edit mode if you would like to use Macros to cross them.

Re: Can I cross variables already added to a model (fit model)?

dacotton — Tue, 07 Jul 2020 15:25:49 GMT

@Mark_Bailey

Thank you for the idea!