topic Re: Move SAS Macro variable from Local session to Server Session in New SAS User

Move SAS Macro variable from Local session to Server Session

dcortell — Tue, 08 Oct 2019 16:00:42 GMT

Hi All

I have within the same SAS EG project two programs:

One working locally, the latter working on a unix server.

I would declare the macro variables just once in the first program (the local one) and then being able to import the macro variables within the server session too.

I searched on the web but I got not straight answer to this topic. Any idea about how I should proceed?

Bests

Re: Move SAS Macro variable from Local session to Server Session

Kurt_Bremser — Tue, 08 Oct 2019 16:11:19 GMT

The only way this would be possible (in a straightforward way) would be to use SAS/CONNECT if it was licensed and installed on both platforms, but then you would start the server session from the local session, and not from EG itself.

Alternatively, you could store the name/value pairs for macrovars in a dataset, move that to the server (Copy Files or Upload Dataset task), and recreate the macrovars in a data step.

Re: Move SAS Macro variable from Local session to Server Session

Reeza — Tue, 08 Oct 2019 16:51:04 GMT

You can look at %SYSLPUT/%SYSRPUT() which works on Foundation SAS. Not sure how it will work within EG where you're working locally and on the server though.

Re: Move SAS Macro variable from Local session to Server Session

dcortell — Wed, 09 Oct 2019 09:19:28 GMT

Tried something like this in the local program:

%let unixsrv= misci01p.unx.xxxx.com 8561; 
 
options comamid=tcp;
 
signon unixsrv user='' password=""; 
 
options remote=unixsrv; 

%syslput start_dt=&start_dt; 
 
rsubmit;
 
endrsubmit;

signoff unixsrv;

But then It seems not working, as the signon is not happening. Any idea if it is a code matter?

Re: Move SAS Macro variable from Local session to Server Session

Kurt_Bremser — Wed, 09 Oct 2019 09:25:19 GMT

Please post the log from that code (use the {i} button for posting logs).

Re: Move SAS Macro variable from Local session to Server Session

dcortell — Wed, 09 Oct 2019 09:51:01 GMT

ERROR: A communication subsystem partner link setup request failure has occurred.
ERROR: TCP link establishment failed.
2                                                          The SAS System                           11:08 Wednesday, October 9, 2019

ERROR: Remote signon to UNIXSRV canceled.
3                                                          The SAS System                           11:08 Wednesday, October 9, 2019

1          ;*';*";*/;quit;run;
2          OPTIONS PAGENO=MIN;
3          %LET _CLIENTTASKLABEL='import';
4          %LET _CLIENTPROCESSFLOWNAME='Process Flow';
5          %LET _CLIENTPROJECTPATH='C:\Users\spndac\OneDrive -
5        ! SAS\SAS_EG_projects\Attribution_Model_112018\code\CallMarkov_local_Aggr_Simulation_BK.egp';
6          %LET _CLIENTPROJECTPATHHOST='spnb147b';
7          %LET _CLIENTPROJECTNAME='CallMarkov_local_Aggr_Simulation_BK.egp';
8          %LET _SASPROGRAMFILE='';
9          %LET _SASPROGRAMFILEHOST='';
10         
11         ODS _ALL_ CLOSE;
12         OPTIONS DEV=PNG;
13         GOPTIONS XPIXELS=0 YPIXELS=0;
14         FILENAME EGSR TEMP;
15         ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR
16             STYLE=HTMLBlue
17             STYLESHEET=(URL="file:///C:/Program%20Files%20(x86)/SASHome/x86/SASEnterpriseGuide/7.1/Styles/HTMLBlue.css")
18             NOGTITLE
19             NOGFOOTNOTE
20             GPATH=&sasworklocation
SYMBOLGEN:  Macro variable SASWORKLOCATION resolves to 
            "C:\Users\spndac\AppData\Roaming\SAS\EnterpriseGuide\EGTEMP\SEG-19212-2afa42b0\contents\SAS Temporary 
            Files\_TD7764_spnb147b_\Prc2/"
21             ENCODING=UTF8
22             options(rolap="on")
23         ;
NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR
24         
25         GOPTIONS ACCESSIBLE;
SYMBOLGEN:  Macro variable START_DT resolves to "02Jul2018"d
26         %put &start_dt;
"02Jul2018"d
27         
28         %let unixsrv= misci01p.unx.xxxx.com 8561;
29         
30         signon unixsrv user=xxxx password=XXXXXXXXXXXX;
NOTE: Remote signon to UNIXSRV commencing (SAS Release 9.04.01M6P110718).

Attached the log with errors

Re: Move SAS Macro variable from Local session to Server Session

Kurt_Bremser — Wed, 09 Oct 2019 10:14:15 GMT

You use the wrong port; 8561 is the Metadata Server. You need to specify the port on which the Connect Spawner is listening. This can be retrieved with the SAS Management Console.

Re: Move SAS Macro variable from Local session to Server Session

dcortell — Wed, 09 Oct 2019 11:22:02 GMT

Switched to

%put &start_dt;

%let unixsrv= misci01p.unx.sas.com 8581; 
 
options comamid=tcp remote=unixsrv;
 
signon unixsrv username='spndac' password="Harker321!"; 
 
%syslput start_dt=&start_dt; 
 
rsubmit;

endrsubmit;

signoff unixsrv;

Which It seems should be the spawner port. However, the code run without an end.

Could be less problematic to create a table on the local session with the macro values, and export it to the server session? But again, how to export that