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.