@teddyee
Below code creates your desired outcome.
data table_a;
infile datalines truncover dlm=' ' dsd;
input customer $ date:anydtdte. filter $;
format date date9.;
datalines;
s8889b 1/2/2017 N
S9990n 2/2/2017 A
T6789p Y
Z1234 4/2/2017
;
run;
data table_b;
infile datalines truncover dlm=' ' dsd;
input customer $ date:anydtdte. filter $;
format date date9.;
datalines;
s8889b 1/1/2017 Y
S9990n 2/2/2017 N
T6789p 3/2/2017 N
Z1234
;
run;
proc sql;
create table want as
select
coalesce(a.customer,b.customer) as customer,
max(a.date,b.date) as date format=date9.,
byte(max(rank(a.filter),rank(b.filter))) as filter
from
table_a as a
full outer join
table_b as b
on
a.customer=b.customer
;
quit;
Please post in the future fully working data steps creating your sample data so we don't have to do this for you.
... View more
