topic Re: Passing a value of macro variable to remote sas session with autosignon in SAS Programming

Passing a value of macro variable to remote sas session with autosignon

sarunas — Tue, 17 Jun 2008 20:18:12 GMT

Dear SAS experts,
I don't know how to pass a value of macro variable to remote asynchronous sas session that was started with RSUBMIT statement with AUTOSIGNON option. With that option I can not exploit %SYSLPUT statement.

Below is an example:

%macro test;

option autosignon=yes;
option sascmd="!sascmd";

%let path = /disk1/folder1;

rsubmit process=ps1 cwait=no;
%include "&path";
endrsubmit;

%mend test;

Could you please help me to find out how could I pass the value of &path to remote sas session.

Thanks in advance

Re: Passing a value of macro variable to remote sas session with autosignon

deleted_user — Wed, 18 Jun 2008 07:17:43 GMT

Hi,

I think %sysLput should work:-) but look

http://support.sas.com/kb/6/883.html

M. Message was edited by: matej@comma

Re: Passing a value of macro variable to remote sas session with autosignon

sarunas — Wed, 18 Jun 2008 10:13:45 GMT

Thanks Matej for your help. I have not seen this information before, but I have experienced it...

Is it something like a gap in interface between sas macro and MP/connect, that there is no way to pass a value of macro variable from client to server sas sessions ?

Re: Passing a value of macro variable to remote sas session with autosignon

deleted_user — Wed, 18 Jun 2008 14:51:25 GMT

You should try something like this. I suppose, that it will work with AUTOSIGNON and CWAIT = NO option too.

%macro test;
%let PATH=/disk1/folder1fsdfsdf;

data LOCAL_MACROS;
length PATH $2000;
PATH = "&path";
run;

rsubmit;
proc upload data = LOCAL_MACROS OUT = SERVER_MACROS;
run;

data _null_;
set SERVER_MACROS;
call symPut("S_PATH", PATH);
run;
endrsubmit;
%mend;
%test;

rsubmit;
%put &S_PATH;
endrsubmit;

Re: Passing a value of macro variable to remote sas session with autosignon

sarunas — Thu, 19 Jun 2008 11:41:14 GMT

Nice work around Matej 😉 Thank a lot for your example 🙂

Regards,
Sarunas