- data temp;
- input date yymmdd10. class $ name $;
- format date yymmdd10.;
- cards;
- 1998/3/1 a 小明
- 1998/3/1 a 小红
- 1998/3/1 a 小美
- 1998/3/1 b 大壮
- 1998/3/1 b 大高
- 1998/3/12 d 小明
- 1998/3/12 d 小溪
- 1998/3/12 d 小何
- 1998/3/12 d 付好
- ;
- run;
- proc sql;
- create table temp1 as
- select a.date,a.class,a.name as aname,b.name as bname
- from temp as a,temp as b
- where a.date = b.date & a.class = b.class & a.name ^= b.name;
- quit;
- data temp2;
- set temp1;
- if aname <= bname then comname = compress(aname)||","||compress(bname);
- else comname = compress(bname)||","||compress(aname);
- run;
- proc sql;
- create table temp3 as
- select distinct date,class,comname from temp2;
- quit;
- data final;
- set temp3;
- aname = scan(comname,1);
- bname = scan(comname,2);
- drop comname;
- run;