topic Re: Permutations combinations in SAS Programming

Permutations combinations

meckarthik — Mon, 09 Dec 2019 16:18:47 GMT

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

Re: Permutations combinations

Reeza — Mon, 09 Dec 2019 16:29:40 GMT

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

Re: Permutations combinations

meckarthik — Mon, 09 Dec 2019 16:33:53 GMT

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

Re: Permutations combinations

Reeza — Mon, 09 Dec 2019 17:17:02 GMT

What do you start out with exactly then?

Re: Permutations combinations

meckarthik — Mon, 09 Dec 2019 17:46:35 GMT

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

Re: Permutations combinations

Reeza — Mon, 09 Dec 2019 17:59:53 GMT

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

Re: Permutations combinations

meckarthik — Mon, 09 Dec 2019 18:01:25 GMT

So sorry it's two columns only

Re: Permutations combinations

meckarthik — Mon, 09 Dec 2019 18:01:40 GMT

2 way match will do, thanks

Re: Permutations combinations

Reeza — Mon, 09 Dec 2019 18:05:44 GMT

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.

Re: Permutations combinations

meckarthik — Mon, 09 Dec 2019 18:13:57 GMT

2 by 2 matrix only.

Re: Permutations combinations

Reeza — Mon, 09 Dec 2019 18:17:27 GMT

I don't know what that means.

Re: Permutations combinations

meckarthik — Mon, 09 Dec 2019 18:20:06 GMT

Thanks I will work on this and feedback.

Re: Permutations combinations

meckarthik — Fri, 13 Dec 2019 14:30:24 GMT

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

Re: Permutations combinations

meckarthik — Fri, 13 Dec 2019 14:30:57 GMT

& Thank you so much!