- data have;
- input name_co $30. ;
- datalines;
- XiaoMing ZhangSan LiSi
- WangWu XiaoHong
- XiaoHong XiaoMing
- ; run;
- data want;
- set have;
- n=countw(name_co);
- do i = 1 to n-1;
- do j = i+1 to n;
- name = scan(name_co, i);
- co = scan(name_co, j);
- output;
- name = scan(name_co, j);
- co = scan(name_co, i);
- output;
- end;
- end;
- keep name co;
- run;