proc sort data=DSdata._Benchmark1;by date;run;
proc sort data=DSdata._all2;by date;run;
方法一
proc sql;
create table DSdata._all1_Benchmark as
select a.*,b.BDR,b.BLR
from DSdata._all2(rename=(n=nid Date=Date)) as a inner join DSdata._Benchmark1 as b on a.date=b.date ;
quit;


方法二
data DSdata._all1_Benchmark;
merge DSdata._all2 (in=a) DSdata._Benchmark1(in=b);
bydate;
if a=1 and b=1;
rename n=nid;
run;