Help using Base SAS procedures

Left join question

Accepted Solution Solved
Reply
Regular Contributor
Posts: 240
Accepted Solution

Left join question

Hi

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


Accepted Solutions
Solution
‎12-03-2014 05:29 PM
Super Contributor
Posts: 578

Re: Left join question

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

View solution in original post


All Replies
Solution
‎12-03-2014 05:29 PM
Super Contributor
Posts: 578

Re: Left join question

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

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 153 views
  • 0 likes
  • 2 in conversation