hello
i have 4 tables and i need to join them. The 1st table has about 1M records and the other 3 about 20M each but i only need all the records from the 1st with all the coresponding ones from the other 3 tables which means left join on the 1st table would do the job,right?
But how do i do left join with more then 2 tables?
The basic structure is like this:
select a.*, b.x, c.y, d.z
from a left join
b on a.id=b.id left join
c on a.id=c.id left join
d on a.id=d.id
Keep referring to the first table for the joins.
PG
Here is a link to the question asked for MySQL http://stackoverflow.com/questions/7980052/how-to-do-left-join-with-more-than-2-tables
the proc sql syntax should be very similar.
The basic structure is like this:
select a.*, b.x, c.y, d.z
from a left join
b on a.id=b.id left join
c on a.id=c.id left join
d on a.id=d.id
Keep referring to the first table for the joins.
PG
thanks. This is really siimple
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.