tag:blogger.com,1999:blog-7607949.post3297825175473678263..comments2023-08-27T17:57:11.625+10:00Comments on neoporcupine: SAS - How merge (mal)functionsSimonhttp://www.blogger.com/profile/05665625863984599164noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-7607949.post-49481626558428062332009-08-08T13:38:11.455+10:002009-08-08T13:38:11.455+10:00Thanks Firefly,
1) Yes, fixed. Obviously I was wo...Thanks Firefly,<br /><br />1) Yes, fixed. Obviously I was working with test data names.<br /><br />2) Yes full outer join. However your UNION code fails the same as "SAS SQL Full Join" as SAS doesn't like columns with the same name - which means SetB.Alpha goes missing, hence the use of coalesce. Obviously for the sad versions of SQL that don't implement full outer joins then Simonhttps://www.blogger.com/profile/05665625863984599164noreply@blogger.comtag:blogger.com,1999:blog-7607949.post-1422566887082433482009-08-07T08:19:03.501+10:002009-08-07T08:19:03.501+10:00Comment 1:
The 'where' clause in "SAS...Comment 1:<br />The 'where' clause in "SAS SQL Simple Join" may need to be looked at.<br /><br />Comment 2:<br />I think overall your trying to get a Full Outer Join (http://en.wikipedia.org/wiki/Join_%28SQL%29#Full_outer_join)<br /><br />For what you want does ... using a union of two left joins work?<br /><br />select SETA.*, SETB.* from SETA LEFT JOIN SETB ON SETA.Alpha = Fireflynoreply@blogger.com