Permutations and Combinations

Question

Hi all - Super new here - but tried a bunch of googling around permutations, cluster and combinations, and I'm not sure I'm using the correct vocabulary, so I apologize in advance.

Here's my sample:

A, B, E, F

A, B, G, R

A, R, G, E, B, G, L

A, B, R

A, B

A, Q, B, L, R, Z

I want to find what all the combinations (or is it permutations?) of a set of codes is, so that ultimately, If I find something that matches in every time I see it, I can do something else.  In the above example, I've got A and B happening every time I see code A, or 100%.  I'm not ready to discard the stuff that doesn't match 100% of the time, but it's nice to see them in case I ever want to say, "I see the combination of A, B and R happening 75% of the time"

I have to do this for every code, so while the sample I gave above was for A, I'd want to see this for B, C, etc.  I'm totally fine if I come up with a code G that never matches.  I just need to know all this.

Any help is greatly appreciated.

Thank you.

Mike

cgoodman · Answer

It sounds like you might need a batch macro instead of an iterative one.

For example, if you want to do it for all the combinations that start with A and then C then a batch macro is the way to go.

If you put a filter tool at the start and put a condition that is Left([String],1) = "A" then connect a control parameter to the filter with an action tool set to replace the A, with the input of the combination of letters (e.g. next batch would be "C"). Then after this do you market basket analysis.

mw42 · Answer

My brain will not wrap itself around iterative macros (for that matter, batch macros) and how to incorporate sql.

So this workflow i think should be iterative.  I'm simply creating some concatenated strings to throw through the market basket.  I just need to do it one section of data at a time.  The above example throws everything through at once, which doesn't give me the answer I need.

The problem is, my input file contains all the records I want to process.  But, I want to process them through the market basket in groups, or using the data - one "code" at a time, and I want my output to be unioned for each code.

Hope that better explains this.

WorkflowForPosting.yxmd

damc · Answer

Hello @mw42 ,

Not sure if I got your question right this time…So, given the list of patients and a given symptom you need to filter all the patients with this symptom, then calculate the combinations considering this subset. Adittionaly, you need to repeat this operation for each other symptom… Did I get it?

If so, this is possible using an iterative macro. I´ve attached a package with a macro for this purpose.

Hope it helps

Regards

Note: in case you´re new to iterative macros,  I believe this video will be handy (thanks for the video @carlosteixeira  😉)

https://www.youtube.com/watch?v=0AGpVm9H1I4&feature=emb_logo

hyperedges_iteration.yxzp