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; ... View more

This is tricky stuff to trouble shoot, especially via a forum. It should work... So where do you store the userid/psw? In the user group account (I hope)? Do you use AUTHDOMAIN= in your library definition? Logs, it not always obvious which log to look in: The DI Studio Log of course. Adding options sastrace=',,,d' sastraceloc=saslog nostsuffix msglevel=i; might give you some more info. Metadata server log, holds authentication info Even the Object Spawner log might give some clues ... View more

Thanks Michelle. ... View more