表1:
FINESS SIRET YEAR
1 A 2000
1 B 2001
2 C 2000
2 D 2001
4 F 2000
4 G 2001
. . .
. . .
. . .
表2:
FINESS SIRET YEAR
1 A 2000
2 C 2000
3 E 2000
6 H 2000
. . .
. . .
proc sql;
create table same_sheet as
select a.*,b.*
from 表一 as a inner join 表二 as b
on a.finess=b.finess and a.SIRET =b.SIRET and a.year=b.year
;
quit;
proc sort data=a;
by FINESS siret year;
run;
proc sort data=b;
by FINESS siret year;
run;
data c;
merge a(in=a) b(in=b);
by FINESS siret year;
if a and b;
run;