topic Re: proc sql-- left join question in SAS Procedures

proc sql-- left join question

ping — Tue, 26 Nov 2013 18:11:16 GMT

select a.*, b.* from a left join b on a.key=b.key I want all a rows and matched b rows, but not including those b rows with empty key. Q1: if a.key=missing and b.key=missing then they will be matched. How to avoid that? Q2: if I add "where b.key is not missing", all rows with a.key=missing will be removed. So, WHERE is applied after Left Join? Any efficient way?

Re: proc sql-- left join question

PaigeMiller — Tue, 26 Nov 2013 19:06:21 GMT

select a.*, b.* from a left join b(where=(not missing(key)))

Re: proc sql-- left join question

ping — Tue, 26 Nov 2013 20:28:59 GMT

thanks.