I have two tables 1 and 2. Table 1 contains lenfol's values and it's matching Survival Distribution Function Estimate's values. In table 2, I want to add a column which store Survival Distribution Function Estimate's values which match lenfol's values in table 1. Can somebody point me in the way how I can set that up? Thanks!
Table 1
Table 2
If you can put your data into csv files and attach them, it should be pretty straight forward…
I could write up code which'd probably work, but it could quite possibly not work too!
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;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.