Enterprise Guide - Update

[prenderj]

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.

[anoopmohandas7]

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;