Enterprise Guide - Update

prenderj — Mon, 27 Apr 2015 15:13:38 GMT

Hi,

I am trying to run the following update in Enterprise Guide and I am getting the following error "ERROR 73-322: Expecting an =."

Can anyone see where I'm going wrong?

proc sql;

update DEV_MART.CHURN_MART_WITH_CONTROL_GROUP A

set A.AVONDHU_GROUP =

(select b.AVONDHU_GROUP

from PD_DATA.OUTBOUND_CLASSIFICATION B

where B.MAIN_MEM_NO=A.MAIN_MEM_NO

AND B.RENEWAL_DATE = A.RENEW_DT

AND B.RUN_DATE = A.SCORE_DT)

where exists (

select 1

from PD_DATA.OUTBOUND_CLASSIFICATION B

where B.MAIN_MEM_NO = A.MAIN_MEM_NO

AND B.RENEWAL_DATE = A.RENEW_DT

AND B.RUN_DATE = A.SCORE_DT);

quit;

Thanks.

Re: Enterprise Guide - Update

anoopmohandas7 — Wed, 26 Oct 2016 23:37:57 GMT

Prenderj,

Try the below. theas

proc sql;

update DEV_MART.CHURN_MART_WITH_CONTROL_GROUP as A

set A.AVONDHU_GROUP =

(select b.AVONDHU_GROUP

from PD_DATA.OUTBOUND_CLASSIFICATION B

where B.MAIN_MEM_NO=A.MAIN_MEM_NO

AND B.RENEWAL_DATE = A.RENEW_DT

AND B.RUN_DATE = A.SCORE_DT)

where exists (

select 1

from PD_DATA.OUTBOUND_CLASSIFICATION B

where B.MAIN_MEM_NO = A.MAIN_MEM_NO

AND B.RENEWAL_DATE = A.RENEW_DT

AND B.RUN_DATE = A.SCORE_DT);

quit;