Excellent !!! I got the following to work: proc sql; create table want as select coalesce(a.name,b.name) as name , coalesce(a.pport,b.zport) as port , a.pport , b.zport from a full join b on a.name=b.name and a.pport=b.zport order by 1,2 ; quit; Now, one last step.... All observations are correct except for the following. I have some observations that look like this: OBS NAME PORT PPORT ZPORT 36 IZUSVR1 10446 10446 . 37 IZUSVR1 15448 . 15448 What is the best way to merge these observations into one ? NAME PPORT ZPORT IZUSVR1 10446 15448 Thank you for all your help !!! Best Regards, Ed
... View more