topic Full outer join in EG in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/Full-outer-join-in-EG/m-p/128668#M10566 <HTML><HEAD></HEAD><BODY><P>Whilst working in EG 5.1 I found out the full outer join of two tables didn't work as expected. In the result all missing values were, well, missing. As far as I know a full outer join should combine the tables as a whole, carrying along the missing values as well. Our SAS consultant says the full outer join doesn't work the way it should.</P></BODY></HTML> Mon, 08 Jul 2013 13:51:23 GMT RvandenDungen 2013-07-08T13:51:23Z Full outer join in EG https://communities.sas.com/t5/SAS-Enterprise-Guide/Full-outer-join-in-EG/m-p/128668#M10566 <HTML><HEAD></HEAD><BODY><P>Whilst working in EG 5.1 I found out the full outer join of two tables didn't work as expected. In the result all missing values were, well, missing. As far as I know a full outer join should combine the tables as a whole, carrying along the missing values as well. Our SAS consultant says the full outer join doesn't work the way it should.</P></BODY></HTML> Mon, 08 Jul 2013 13:51:23 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Full-outer-join-in-EG/m-p/128668#M10566 RvandenDungen 2013-07-08T13:51:23Z Re: Full outer join in EG https://communities.sas.com/t5/SAS-Enterprise-Guide/Full-outer-join-in-EG/m-p/128669#M10567 <HTML><HEAD></HEAD><BODY><P>A full outer join will return all the records from both tables, matching up records based on the join condition.&nbsp; But including the records from "both sides" even when there isn't a match.</P><P></P><P>There is a good description here:</P><P><A href="http://support.sas.com/resources/papers/proceedings10/139-2010.pdf" title="http://support.sas.com/resources/papers/proceedings10/139-2010.pdf">http://support.sas.com/resources/papers/proceedings10/139-2010.pdf</A></P><P></P><P>The Query Builder generates the FULL JOIN syntax for the SQL step.&nbsp; If the results aren't what you expect, perhaps you can provide more details about your data tables and we can help to diagnose it.</P><P></P><P>If you're looking for a UNION - like an Append behavior -- try the Data-&gt;Append Table task.</P><P></P><P>Chris</P></BODY></HTML> Mon, 08 Jul 2013 14:21:57 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Full-outer-join-in-EG/m-p/128669#M10567 ChrisHemedinger 2013-07-08T14:21:57Z