Hi, I've copied the log and code below. Thanks, Paul 1 The SAS System 16:06 Thursday, January 18, 2018 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='ANI Match'; 4 %LET _CLIENTPROCESSFLOWNAME='Process Flow'; 5 %LET _CLIENTPROJECTPATH=''; 6 %LET _CLIENTPROJECTNAME=''; 7 %LET _SASPROGRAMFILE=; 8 9 ODS _ALL_ CLOSE; 10 OPTIONS DEV=ACTIVEX; 11 GOPTIONS XPIXELS=0 YPIXELS=0; 12 FILENAME EGSR TEMP; 13 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR 14 STYLE=HtmlBlue 15 STYLESHEET=(URL="file:///C:/Program%20Files/SASHOME2/SASEnterpriseGuide/7.1/Styles/HtmlBlue.css") 16 NOGTITLE 17 NOGFOOTNOTE 18 GPATH=&sasworklocation 19 ENCODING=UTF8 20 options(rolap="on") 21 ; NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR 22 23 GOPTIONS ACCESSIBLE; 24 rsubmit; ERROR: Invalid or unspecified remote session ID. Set OPTIONS REMOTE=session_id. NOTE: Subsequent lines will be ignored until ENDRSUBMIT. ERROR: Remote submit to UNKNOWN canceled. 25 26 GOPTIONS NOACCESSIBLE; 27 %LET _CLIENTTASKLABEL=; 28 %LET _CLIENTPROCESSFLOWNAME=; 29 %LET _CLIENTPROJECTPATH=; 30 %LET _CLIENTPROJECTNAME=; 31 %LET _SASPROGRAMFILE=; 32 33 ;*';*";*/;quit;run; 34 ODS _ALL_ CLOSE; 35 36 37 QUIT; RUN; 38 rsubmit; libname schulten '/workspace/lob2/wellsmktg/paul'; proc sql; connect to aster (server="edaast1q.wellsfargo.com" database='EDAASTPRD' user='&LANID' password='&LANPWD'); drop table FRAC.cust_interactions; create table FRAC.cust_interactions as select * from connection to aster( SELECT distinct a.cust_num, b.ANI_NUMBER, a.start_date, b.connid, a.dnis FROM "sbx_fraud_frac"."infomart_detail" a INNER JOIN "sbx_fraud_frac"."infomart_summary" b on a.interaction_id = b.interaction_id WHERE a.start_date >=current_date -1 and (a.cust_num is not null) and exit_reason not in ('CORE ACTIVATION', 'MARCELLUS ACTIVATION', 'TPB WFA PREMIER ACTIVATION', 'TPB_ACTIVATION', 'cc_lost'); ); disconnect from aster; quit; endrsubmit;
... View more