proc sql-- left join question

[ping]

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?

[PaigeMiller · Accepted solution]

Q1

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

[ping]

thanks.