topic left join with more tables in SAS Procedures

left join with more tables

Tal — Tue, 14 Jul 2015 19:18:02 GMT

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?

Re: left join with more tables

morgalr — Tue, 14 Jul 2015 22:23:29 GMT

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.

Re: left join with more tables

PGStats — Wed, 15 Jul 2015 01:32:36 GMT

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.

Re: left join with more tables

Tal — Wed, 15 Jul 2015 19:54:01 GMT

thanks. This is really siimple