topic Macro for remote problem in SAS Procedures

Macro for remote problem

Mike_Davis — Tue, 22 May 2012 16:52:36 GMT

Hello Everyone!

I have a problem to create a macro in local for running a remote code: method 1 works well,but method 2 doesn't work. what is the problem with method 2??

Thanks!

Mike

rsubmit;

data z;

x=123;

run;

endrsubmit;

method 1:/*create remote macro,this method works well*/

rsubmit;

%macro mm;

data _null_;

set z;

call symputx('aaa',x);

run;

%put &aaa;

%mend mm;

%mm; /*this will show 123 in the log*/

endrsubmit;

method 2:/*create a local macro*/

%macro mm2;
rsubmit;
data _null_;
set z;
call symputx('bbb',x);
run;
%put &bbb;
endrsubmit;
%mend mm2;

%mm2; /*This will not work ,why?*/

Re: Macro for remote problem

Mike_Davis — Tue, 22 May 2012 17:47:34 GMT

To simply the question like this:

rsubmit;
%let aaa=123456;

endrsubmit;

/***********************************************/

rsubmit;

%put &aaa;/*this works*/

endrsubmit;

/**********************************************************/

%macro kk;
rsubmit;
%put &aaa;
endrsubmit;
%mend kk;
%kk;/*This doesn't work*/

Thanks!

Re: Macro for remote problem

Mike_Davis — Tue, 22 May 2012 17:57:56 GMT

http://support.sas.com/techsup/technote/ts697.pdf

Re: Macro for remote problem

Mike_Davis — Tue, 22 May 2012 17:59:43 GMT

%macro mm2;

%nrstr(

rsubmit;

data _null_;

set z;

call symputx('bbb',x);

run;

%put &bbb;

endrsubmit;

);

%mend mm2;

%mm2;

Re: Macro for remote problem

Jay_TxOAG — Thu, 24 May 2012 12:21:13 GMT

Thanks for that...I always wondered why I coudn't assign a macro in my remote session