Repeat Regression and Score on Multiple Groups

Nate

Hello. I have a set of data on which I would like to run the same regression model for multiple groups. The groups are defined by a column in the input data. For each regression I want to score the model and append each set of predictions to one output data.

It seems like a batch macro would do this, but I'm not sure where to start. Any tips would be appreciated.

Cheers!

KaneG

Hi Nate,

The best way that I find to create a batch macro is filter down to one of your 'batches' and then create your flow. Everything after the filter will later become your batch macro with the groups field being your Control Parameter. So, in the very simple case, your workflow would look like this:

Then you want to turn everything after the filter into a batch macro, which will look like this:

The Control Parameter will work like your filter. Make sure that Batch Macro is selected under the Workflow Configuration. Icons and so forth can be changed in the Interface Designer.

Then your workflow can be summarised to the following, just select your grouping fields on the Macro Configuration on this workflow:

Kane