topic Re: 2*2 paring in SAS Programming

2*2 paring

cindyforest7 — Wed, 20 May 2015 20:30:40 GMT

Hello everyone,

I have a list of providers, and I want to create a second dataset with each provider paired with one other provider. A provider will not be paired to itself.

table have

provider_id

....

table want

provider id1 provider id2

a b

a c

a d

a e

b c

b d

b e

c d

c e

d e

Thanks advance for all the inputs!!!

Re: 2*2 paring

ballardw — Wed, 20 May 2015 20:39:22 GMT

It appears that you have a second requirement that if the a-b pair has been generated that you do not want b-a. Is that correct?

Re: 2*2 paring

stat_sas — Wed, 20 May 2015 20:51:39 GMT

data have;

input provider_id $;

datalines;

;

proc sql;

create table want as

select a.provider_id as provider_id1, b.provider_id as provider_id2 from have a

cross join have b

where a.provider_id<b.provider_id;

quit;

Re: 2*2 paring

cindyforest7 — Wed, 20 May 2015 21:18:27 GMT

Correct.

Re: 2*2 paring

Ksharp — Fri, 22 May 2015 12:01:51 GMT

You are trying to get all the combination of ID . OR try to use function COMB() .

data have;
input provider_id $;
datalines;
a
b
c
d
e
;
run;
data want;
 set have end=last;
 array x{9999999} $ _temporary_;
 x{_n_}=provider_id;
 if last then do;
  do i=1 to _n_-1;
   do j=i+1 to _n_;
     id1=x{i};id2=x{j};output;
   end;
  end;
end;
keep id1 id2;
run;

Xia Keshan