Permutations combinations

[meckarthik]

Hi , I got two columns
1 aa
2 bb
3 cc

How to code in sas for combination
I want output to look like

1 aa
1 BB
2 aa
12 as
13 bb
123 aa
Etc
All possible combinations

Thanks

[Reeza]

How do you get 12 as?
What's the logic here, all combinations of a/b/c?

---

@meckarthik wrote:
Hi , I got two columns
1 aa
2 bb
3 cc

How to code in sas for combination
I want output to look like

1 aa
1 BB
2 aa
12 as
13 bb
123 aa
Etc
All possible combinations

Thanks

---

[meckarthik]

Hey, sorry typo error. Yes I want all combinations of a/b/c . That should also include abc1, bc1, 123abc etc. Let me know if it doesn't make sense

[Reeza]

What do you start out with exactly then?

[meckarthik]

I start with
Single match
1 a
2 a
Etc
Goes maximum 3 from column a and 3 from column b
Something like 3*3 matrices
123 ABC
123 acb
231 CBA
Whether it make sense
Thanks for helping on this

[Reeza]

You've gone from 2 matches, aa, ab, ac among three options to three way matches which is different.....so which is it?

[meckarthik]

So sorry it's two columns only

[meckarthik]

2 way match will do, thanks

[Reeza · Accepted solution]

data t1;
input letter1 $;
cards;
a1
b1
c1
;;;;
data t2;
input letter2 $;
cards;
a2
b2
c2
;;;;

proc sql;
create table want as
select t1.letter1, t2.letter2, catt(t1.letter1, t2.letter2) as comb
from t1, t2;
quit;

That's the quickest coding way.

[meckarthik]

 Hi, expanded the query for 3 tables and it worked perfectly well. Just waiting for the final sign off!!!

[meckarthik]

& Thank you so much!

[meckarthik]

2 by 2 matrix only.

[Reeza]

I don't know what that means.

[meckarthik]

Thanks I will work on this and feedback.