topic Proc Sql 3 Tables Left Join Help Needed in SAS Programming

Proc Sql 3 Tables Left Join Help Needed

val843 — Tue, 01 Apr 2014 03:02:52 GMT

Hi everyone,

I am just learning to code and need assistance on how to join 3 tables. I think there should be a parenthesis somewhere but cant figure it out. Thank you!

proc sql;

create table aero.affiliate_orders as

select a.ordernumber,

a.Affiliate,

a.Revenue,

b.Publisher_category,

c.new_customer

from

aero.clc a

left join

aero.affiliate_cat b

left join

aero.new_repeat_master_customer c

ON a.ordernumber=c.order_number and

a.affiliate = b.company_name

where a.sourcetype="Affiliate"

;quit;

Re: Proc Sql 3 Tables Left Join Help Needed

RichardinOz — Tue, 01 Apr 2014 03:09:22 GMT

Try using a separate ON clause after each left join, rather than a single combined clause after the second join.

Richard

Re: Proc Sql 3 Tables Left Join Help Needed

Reeza — Tue, 01 Apr 2014 04:21:37 GMT

Why do you think you need parenthesis?

Re: Proc Sql 3 Tables Left Join Help Needed

TarunKumar — Tue, 01 Apr 2014 07:07:56 GMT

proc sql;

create table aero.affiliate_orders as

select a.ordernumber,

a.Affiliate,

a.Revenue,

b.Publisher_category,

c.new_customer

from aero.clc a

left join aero.affiliate_cat b

on a.affiliate = b.company_name

left join aero.new_repeat_master_customer c

on a.ordernumber=c.order_number

where a.sourcetype="Affiliate"

;quit;

Re: Proc Sql 3 Tables Left Join Help Needed

val843 — Tue, 01 Apr 2014 15:43:06 GMT

Thanks!