2018-01-30T11:05:37,483 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - MPRINT(STPEND):    options NOTES;
2018-01-30T11:05:37,483 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - MLOGIC(STPEND):  Ending execution.
2018-01-30T11:05:37,483 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - MLOGIC(S_MERGE):  Beginning execution.
2018-01-30T11:05:37,483 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - MPRINT(S_MERGE):   LIBNAME SAS_BASE base "C:\CI\SAS_BASE_LIB";
2018-01-30T11:05:37,483 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - NOTE: Libref SAS_BASE was successfully assigned as follows: 
2018-01-30T11:05:37,483 INFO  [00016284] 334:sasdemo@ETACRMMKT01 -       Engine:        BASE 
2018-01-30T11:05:37,483 INFO  [00016284] 334:sasdemo@ETACRMMKT01 -       Physical Name: C:\CI\SAS_BASE_LIB
2018-01-30T11:05:37,483 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - MPRINT(S_MERGE):   libname mkt oracle path=mkt SCHEMA=CCMKT USER=CCMKT PASSWORD="smart" dbsliceparm=all;
2018-01-30T11:05:37,483 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - NOTE: Libref MKT was successfully assigned as follows: 
2018-01-30T11:05:37,483 INFO  [00016284] 334:sasdemo@ETACRMMKT01 -       Engine:        ORACLE 
2018-01-30T11:05:37,483 INFO  [00016284] 334:sasdemo@ETACRMMKT01 -       Physical Name: mkt
2018-01-30T11:05:37,483 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - MPRINT(S_MERGE):   LIBNAME BICRMMA TERADATA SERVER=BITERADATA SCHEMA=DP_BVEW USER=ETICRM PASSWORD="{SAS002}5FF62C162FA4F37B53CC523625AB8AB1" dbsliceparm=all;
2018-01-30T11:05:37,483 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - NOTE: Libref BICRMMA was successfully assigned as follows: 
2018-01-30T11:05:37,483 INFO  [00016284] 334:sasdemo@ETACRMMKT01 -       Engine:        TERADATA 
2018-01-30T11:05:37,483 INFO  [00016284] 334:sasdemo@ETACRMMKT01 -       Physical Name: BITERADATA
2018-01-30T11:05:37,483 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - MLOGIC(S_MERGE):  %LET (variable name is STD_CODE)
2018-01-30T11:05:37,483 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - MPRINT(S_MERGE):   proc sql;
2018-01-30T11:05:37,483 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - MPRINT(S_MERGE):   create table MATables.TPI2MPVEQ2KUEMAAPsasdemoTn_1 as select a.subs_id as subs_id from mkt.afa_subs_campaign a,MATables.TPI2MPVEQ2KUE0AAQsasdemo b where a.std_code="30" and 
2018-01-30T11:05:37,483 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - a.subs_id=b.subs_id;
2018-01-30T11:05:37,483 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - NOTE: Table MATABLES.TPI2MPVEQ2KUEMAAPSASDEMOTN_1 created, with 1 rows and 1 columns.
2018-01-30T11:05:37,483 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - 
2018-01-30T11:05:37,483 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - MPRINT(S_MERGE):   quit;
2018-01-30T11:05:37,483 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - NOTE: PROCEDURE SQL used (Total process time):
2018-01-30T11:05:37,483 INFO  [00016284] 334:sasdemo@ETACRMMKT01 -       real time           1:59.34
2018-01-30T11:05:37,483 INFO  [00016284] 334:sasdemo@ETACRMMKT01 -       cpu time            6.66 seconds
2018-01-30T11:05:37,483 INFO  [00016284] 334:sasdemo@ETACRMMKT01 -       
2018-01-30T11:05:37,483 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - 
2018-01-30T11:05:37,483 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - MLOGIC(S_MERGE):  %PUT SQLEXITCODE2=&SQLEXITCODE
2018-01-30T11:05:37,483 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - SQLEXITCODE2=0
2018-01-30T11:05:37,483 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - MLOGIC(S_MERGE):  %PUT SQLOBS2=&SQLOBS
2018-01-30T11:05:37,483 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - SQLOBS2=1
2018-01-30T11:05:37,483 INFO  [00016284] 334:sasdemo@ETACRMMKT01 -                                                                                           The SAS System
2018-01-30T11:05:37,483 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - 
2018-01-30T11:05:37,483 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - MPRINT(S_MERGE):   proc sql;
2018-01-30T11:05:37,483 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - MPRINT(S_MERGE):   CREATE TABLE MATables.TPI2MPVEQ2KUEMAAPsasdemoTn_2 AS select b.subs_id from bicrmma.sms_opt_out a, bicrmma.cc_subs_basic b,MATables.TPI2MPVEQ2KUE0AAQsasdemo c where 
2018-01-30T11:05:37,483 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - a.msisdn=b.acc_nbr and b.subs_id=c.subs_id;
2018-01-30T11:05:37,483 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - NOTE: Table MATABLES.TPI2MPVEQ2KUEMAAPSASDEMOTN_2 created, with 1 rows and 1 columns.
2018-01-30T11:05:37,483 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - 
2018-01-30T11:05:37,483 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - MPRINT(S_MERGE):   quit;
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - NOTE: PROCEDURE SQL used (Total process time):
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 -       real time           1:50.35
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 -       cpu time            46.59 seconds
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 -       
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - 
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - MLOGIC(S_MERGE):  %PUT SQLEXITCODE1=&SQLEXITCODE
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - SQLEXITCODE1=0
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - MLOGIC(S_MERGE):  %PUT SQLOBS1=&SQLOBS
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - SQLOBS1=1
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - MPRINT(S_MERGE):   proc sql;
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - MPRINT(S_MERGE):   create table MATables.TPI2MPVEQ2KUEMAAPsasdemoTn_3 as select subs_id as subs_id from MATables.TPI2MPVEQ2KUE0AAQsasdemo ;
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - NOTE: Table MATABLES.TPI2MPVEQ2KUEMAAPSASDEMOTN_3 created, with 4 rows and 1 columns.
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - 
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - MPRINT(S_MERGE):   quit;
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - NOTE: PROCEDURE SQL used (Total process time):
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 -       real time           0.00 seconds
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 -       cpu time            0.00 seconds
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 -       
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - 
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - MLOGIC(S_MERGE):  %PUT SQLEXITCODE1=&SQLEXITCODE
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - SQLEXITCODE1=0
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - MLOGIC(S_MERGE):  %PUT SQLOBS1=&SQLOBS
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - SQLOBS1=4
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - MPRINT(S_MERGE):   proc sql;
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - MPRINT(S_MERGE):   delete from MATables.TPI2MPVEQ2KUEMAAPsasdemoTn_3 where subs_id in (select subs_id from MATables.TPI2MPVEQ2KUEMAAPsasdemoTn_1);
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - NOTE: 1 row was deleted from MATABLES.TPI2MPVEQ2KUEMAAPSASDEMOTN_3.
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - 
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - MPRINT(S_MERGE):   delete from MATables.TPI2MPVEQ2KUEMAAPsasdemoTn_3 where subs_id in (select subs_id from MATables.TPI2MPVEQ2KUEMAAPsasdemoTn_2);
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - NOTE: 1 row was deleted from MATABLES.TPI2MPVEQ2KUEMAAPSASDEMOTN_3.
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - 
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - MPRINT(S_MERGE):   quit;
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - NOTE: PROCEDURE SQL used (Total process time):
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 -                                                                                           The SAS System
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - 
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 -       real time           0.00 seconds
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 -       cpu time            0.00 seconds
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 -       
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - 
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - MPRINT(S_MERGE):   proc sql noprint;
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - MPRINT(S_MERGE):   drop table MATables.TPI2MPVEQ2KUEMAAPsasdemo;
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - WARNING: File MATABLES.TPI2MPVEQ2KUEMAAPSASDEMO.DATA does not exist.
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - WARNING: Table MATABLES.TPI2MPVEQ2KUEMAAPSASDEMO has not been dropped.
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - MPRINT(S_MERGE):   create table MATables.TPI2MPVEQ2KUEMAAPsasdemo as select a.subs_id as subs_id from MATables.TPI2MPVEQ2KUE0AAQsasdemo b, MATables.TPI2MPVEQ2KUEMAAPsasdemoTn_3 a where 
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - a.subs_id=b.subs_id;
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - NOTE: Table MATABLES.TPI2MPVEQ2KUEMAAPSASDEMO created, with 2 rows and 1 columns.
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - 
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - MPRINT(S_MERGE):   quit;
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - NOTE: PROCEDURE SQL used (Total process time):
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 -       real time           0.00 seconds
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 -       cpu time            0.00 seconds
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 -       
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - 
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - MLOGIC(S_MERGE):  %PUT SQLEXITCODE3=&SQLEXITCODE
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - SQLEXITCODE3=0
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - MLOGIC(S_MERGE):  %PUT SQLOBS3=&SQLOBS
2018-01-30T11:05:37,485 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - SQLOBS3=2
2018-01-30T11:05:37,486 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - MLOGIC(S_MERGE):  Ending execution.
2018-01-30T11:05:37,486 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - MLOGIC(INITIALNODE_SETUP):  Beginning execution.
2018-01-30T11:05:37,486 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - MLOGIC(INITIALNODE_SETUP):  %IF condition &INTABLE EQ is FALSE
2018-01-30T11:05:37,486 INFO  [00016284] 334:sasdemo@ETACRMMKT01 - MLOGIC(INITIALNODE_SETUP):  Ending execution.