topic Matching value in two different tables in SAS Programming

Matching value in two different tables

ShinCrayons — Wed, 22 Feb 2017 03:27:24 GMT

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

Re: Matching value in two different tables

LaurieF — Wed, 22 Feb 2017 03:29:18 GMT

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!

Re: Matching value in two different tables

PeterClemmensen — Wed, 22 Feb 2017 07:32:34 GMT

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;