排序就行了

data a;
input  x @@;
cards;
5  14  6  9  10
;
run;

data b;
input x @@;
cards;
14  9  6  5  10
;
run;

proc sql ;
create table cc as
  select a.x as b1,b.x as b2
from work.a a ,work.b b where a.x=b.x;
quit;

/*两列变量前面加相同的编号——两列变量前面应该有共同的变量（比如subjid）？*/
data a;
input id x1 @@;
cards;
1 5 2 14 3 6 4 9 5 10
;
run;

data b;
input id x2 @@;
cards;
2 14 4 9 3 6 1 5 5 10
;
run;
proc sort data=a;by id;run;
proc sort data=b;by id;run;
data aa;
merge a b;
by id ;
run;

十分感谢您的回答，谢谢