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
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 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.