topic Re: Connection String Issue in SAS Programming

Connection String Issue

paul_schulten — Tue, 16 Jan 2018 22:32:42 GMT

Hi,

I think I'm getting these messages because there's a problem with my connection string. Does that sound right? I'm using SAS EG.

ERROR: Invalid or unspecified remote session ID. Set OPTIONS REMOTE=session_id.

ERROR: Remote submit to UNKNOWN canceled.

Thanks!

Re: Connection String Issue

SASKiwi — Wed, 17 Jan 2018 02:58:10 GMT

Please post your complete SAS log showing both the code and the errors.

Re: Connection String Issue

PeterClemmensen — Wed, 17 Jan 2018 06:14:15 GMT

What does your connection string look like?

And post your entire log, makes it much easier to help you 🙂

Re: Connection String Issue

paul_schulten — Thu, 18 Jan 2018 22:19:35 GMT

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;

Re: Connection String Issue

paul_schulten — Tue, 23 Jan 2018 00:29:14 GMT

Hi,

I googled and found something that said rsubmit and endrsubmit where for sas connection which i don't think i have. when i removed the rsubmit and endrsubmit the query ran.

Thanks!

Re: Connection String Issue

SASKiwi — Tue, 23 Jan 2018 03:58:43 GMT

Correct. An RSUBMIT block is only required if you wish to connect to another SAS server from the one you are running on. The RSUBMIT should be preceded by a SIGNON statement to establish a session on the second SAS server - hence the error you were getting.