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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.