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
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
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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.