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

Hi, I am having issues having 2 oracle database connections running concurrently in Data Integration Studio. I had an existing odbc, user group and library for database 1. All worked fine. I then added a new odbc connection, a new library and a new user group. This database has a different username and password to database 1. I have 2 jobs in DI, one referring database 1 the other database 2. If i delete the username and password for the user group database1 and recreate then the job associated with database 2 will work and job 1 will not work. If i then delete the password associated with database 2 and recreate the password then the job associated with database1 will work and job 2 will stop working. So it appears to be the username and password associated with the first user group created that is maintained. Am i missing a link somewhere? Is it possible to have jobs looking at multiple schemas? Where can I locate the log files for DI? Thanks. ... View more

Hi, I have two data sources one with a list of customers and other information (Data Source A - SAS table), and another with a list of customers to be excluded (Data Source B -Excel Doc). Is it possible to write a report in Visual Analytics based on Data Source A which excludes customers that are in Data Source B i.e. is there a facility in VA to do a subquery? Or can this only be done in the Data Builder or another tool such as Enterprise Guide. I am using version 6.4M1 of Visual Analytics. Any guidance would be great. ... View more