proc compare 也许可以

变量命名不规范。找你们的DBA骂一顿。

Use proc means to calculate n mean std min max, if all of them are equal, then they are very very very like to be them same.

可能需要考虑变量相同是指类似两个集合的相等，即无序相等
还是对于某个ID的有序相等
最为一般的方法就是将两个数据集的每个变量按本身排序，然后两两比较，理论上需要比较100×10次
针对某些情况可以优化减少对比次数

data crackman1;
input x y z h;
datalines;
1 2 3 4
3 4 5 5
6 7 8 6
8 9 0 7
6 5 3 8
;
run;
data crackman2;
set crackman1;
keep y h;
rename y=n h=p;
run;
proc transpose data=crackman1 out=crackman11;
var _all_;
run;
proc transpose data=crackman2 out=crackman22;
var _all_;
run;
proc append base=crackman11 data=crackman22;
run;
data crackman11;
set crackman11;
n=compress(cat(of col1-col5));
run;
proc sort data=crackman11;
by n;
run;
data crackman11;
set crackman11;
by n;
if not (first.n and last.n);
run;



这仅仅是一个思路
可以参考