data fruit;
input up down sub_product $ fav $;
datalines;
2 5 apple applepie
3 2 lemon lemontart
4 0 melon melonmilk
7 11 lemon lemontart
19 33 apple applejuice
;
proc sort data=fruit;
run;
data box;
input up down anyy $ okok $;
datalines;
3 6 app appl
5 9 lem lemo
4 0 mel melilk
7 11 lem lemotrt
21 33 appl appleju
;
proc sort data=box;
run;
proc sql;
create table want as
select
coalesce(t1.up,t2.up) as up,
coalesce(t1.down,t2.down) as down,
t1.sub_product,
t1.fav,
t2.anyy,
t2.okok
from fruit t1 full join box t2
on t1.up = t2.up and t1.down = t2.down
;
quit;
results:
here you go...
... View more
