Hi @Patrick
See if this is what you meant:
/* SQL join - not doing the right thing */
proc sql;
create table not_there_yet_want as
select
coalesce(a.name,b.name,c.name) as name
,coalesce(a.age,b.age,c.age) as age
,coalesce(a.weight,b.weight,c.weight) as weight
,coalesce(a.sex,b.sex,c.sex) as sex
from class_A a
full join class_B b
on a.name=b.name
full join class_C c
on coalesce(a.name,b.name)=c.name
order by name
;
quit;
... View more
