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;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.