请检查一下表3的第二行，等级是否应该为1，以及最后一行，等级是否应该为4？
如果是，请试一下：

data t1;
input sow $ _515512 _406330 _511706 _510169 _510887 _510965 _512266;
cards;
300137 1 . . . . . .
511363 . . 1 . . . .
511099 . . . . 3 . 4
402576 . . . 5 . . 2
511593 2 . . 5 3 . 4
405033 . 2 . 4 1 . 3
511454 5 . . . . . 3
402980 . 2 . 4 1 . 3
;

data t2;
  input sow $ boar $;
  cards;
300137 406330
511363 511706
511099 510887
402576 510169
511593 515512
405033 511706
511454 510169
402980 510169
;

proc transpose data=t1 out=v_t1;
by sow notsorted;
var _515512 -- _512266;
run;

data v_t11;
set v_t1;
boar=strip(substr(_name_,2));
if col1=. then col1=0;
run;

proc sql;
create table wanted as
select a.*, b.col1 as level
from t2 a left join v_t11 b
on a.sow=b.sow and a.boar=b.boar;
quit;