proc sql; select coalesce(b.emp, a.emp) as emp, coalesce(b.sal, a.sal) as sal from a full outer join b on a.emp=b.emp; quit; @varmalh wrote: Hello all, can someone please help me to get the same output from SQL as i am getting from base SAS from the below code....????   data a; input emp$ sal; cards; emp1 1000000 emp2 2000000 emp3 3000000 ;run; data b; input emp$ sal; cards; emp1 1000000 emp3 7000000 emp4 4000000 ;run; data c; update a b; by emp; run; data c; merge a(in=x) b(in=y); by emp; run;  output should be like below: --------------------- emp1 1000000 emp2 2000000 emp3 7000000 emp4 4000000 ---------------------     Thanks and Regards varmalh   ... View more