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;
