Iterative Macro - Correlation

Question

Hi All,

Can someone help me with an iterative macro? I want to calculate correlation by group and the macro I created does not loop. I also want to append all the results, not just post the first or last one. Workflow is attached.

Thanks in advance!!!

correlationmacro.yxmc

philipmannering · Accepted Answer

Hi @rheepa

I think this would work better as a Batch Macro. See my example attached.

Let me know if you have any questions!