post=1;city='a';output;
post=2;city='b';output;
run;
data file2;
post=1;city='a';seg='x';
run;
data file3;
post=2; seg='y';
run;
proc sql ;
create table temp as
select a.post as post ,a.city as city,b.seg as seg
from file1 as a left join file2 as b on a.post=b.post and a.city=b.city;
create table want as
select a.post as post ,a.city as city,coalesce(a.seg,b.seg) as seg
from temp as a left join file3 as b on a.post=b.post;
quit;
[pre]
Ksharp
[/pre]
Message was edited by: Ksharp
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 the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.