topic Re: Full outer Join in SAS EG in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/Full-outer-Join-in-SAS-EG/m-p/159761#M12437 <HTML><HEAD></HEAD><BODY><P>I suggest that you don't do that, as the fact that the key value is missing is the indication that the record only contains data from one table, not both.</P><P></P><P>However, it is easy to create an expression to create a new variable to do exactly that. I tried it with the SASHELP.CLASS dataset, and when I create a new variable whose value is</P><P></P><P>(coalesce(t1.Name, t2.Name)) AS CombinedKey </P><P></P><P>it contains the complete set of keys.</P><P></P><P>Tom</P></BODY></HTML> Sun, 29 Jun 2014 13:58:48 GMT TomKari 2014-06-29T13:58:48Z Full outer Join in SAS EG https://communities.sas.com/t5/SAS-Enterprise-Guide/Full-outer-Join-in-SAS-EG/m-p/159760#M12436 <HTML><HEAD></HEAD><BODY><P>When I join 2 tables in SAS EG using full outer join and include the primary key from the first table in the output, I see missing values in some places because the record for this row exist only in 2nd table and not in 1st table. How to get the primary key from 2nd table to reflect instead of missing value?</P></BODY></HTML> Sun, 29 Jun 2014 07:39:34 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Full-outer-Join-in-SAS-EG/m-p/159760#M12436 Abu_Fudail 2014-06-29T07:39:34Z Re: Full outer Join in SAS EG https://communities.sas.com/t5/SAS-Enterprise-Guide/Full-outer-Join-in-SAS-EG/m-p/159761#M12437 <HTML><HEAD></HEAD><BODY><P>I suggest that you don't do that, as the fact that the key value is missing is the indication that the record only contains data from one table, not both.</P><P></P><P>However, it is easy to create an expression to create a new variable to do exactly that. I tried it with the SASHELP.CLASS dataset, and when I create a new variable whose value is</P><P></P><P>(coalesce(t1.Name, t2.Name)) AS CombinedKey </P><P></P><P>it contains the complete set of keys.</P><P></P><P>Tom</P></BODY></HTML> Sun, 29 Jun 2014 13:58:48 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Full-outer-Join-in-SAS-EG/m-p/159761#M12437 TomKari 2014-06-29T13:58:48Z