Desktop productivity for business analysts and programmers

Enterprise Guide - Update

Reply
Occasional Contributor
Posts: 9

Enterprise Guide - Update

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.

Contributor
Posts: 44

Re: Enterprise Guide - Update

[ Edited ]

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;

Ask a Question
Discussion stats
  • 1 reply
  • 298 views
  • 0 likes
  • 2 in conversation