topic Re: Left join question in SAS Procedures

Left join question

BETO — Wed, 03 Dec 2014 22:10:27 GMT

I have a left join that is only is more like a join .here is what I have

From table A left join table B on a.id=b.id

Where a.date=b.date

);

Run;

I would like everything from table A an where we match from table B

I get back everything we match

Re: Left join question

DBailey — Wed, 03 Dec 2014 22:29:14 GMT

by including "where a.date=b.date" in the criteria, you have converted from a left join to an inner join. To make sure it is still a left join, you need to include that as part of the "on" clause...

from

tableA A

left join tableB B

on a.id=b.id and a.date=b.date