Posting sample data slong with your question makes it a lot easier to solve. But what you are looking for is probably something like this: proc sql;
create table yourtable as
select a.*
,b.Survival_Distribution
from table2 as a left join table1 as b
on a.lenfol = b.lenfol;
quit;
... View more