topic Re: Combination Problem in SAS Programming

Combination Problem

Pratik612_ — Thu, 06 Jun 2019 13:53:39 GMT

Hi,

I have 3 variables and want to find all the possible combinations of two variables that satisfy a particular condition.

example:

t1 t2 t3

1 2 3

1 1 2

4 3 1

Condition: Sum of any two variable >=4.

Answer: 1-->(2,3) 2-->() 3-->(4,3) (3,1) (4,1)

Kindly provide a solution using arrays,allcomb and other basic procedures if possible.

Thank You.

Re: Combination Problem

VDD — Thu, 06 Jun 2019 14:06:03 GMT

What have you tried?

How to create a data-step version of your data
https://communities.sas.com/t5/help/faqpage/faq-category-id/posting#posting

https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712

How to Add attachments
https://communities.sas.com/t5/Community-Memo/Adding-attachments-to-your-communities-posts/ba-p/464767

Re: Combination Problem

Ksharp — Thu, 06 Jun 2019 14:20:48 GMT

data have;
input t1  t2  t3 ;
cards;
1  2   3
1  1   2
4  3   1
;
data want;
 set have;
 id+1;
 array x{*} t1-t3;
 do i=1 to dim(x)-1; 
  do j=i+1 to dim(x);
    if sum(x{i},x{j})>=4 then do;want=cats('(',x{i},',',x{j},')');output;end;
  end;
 end;
 drop i j;
run;