topic Re: Is it advisable to write macros within RSUBMIT & ENDRSUBMIT? in SAS Programming

Is it advisable to write macros within RSUBMIT & ENDRSUBMIT?

Santt0sh — Wed, 13 Apr 2022 02:17:23 GMT

Hi All,

Could you please advise me, if Macros can be written within RSUBMIT and ENDRSUBMIT?

Rsubmit;

%MACRO SRTDT(BGNDTE=);

%do i = 1 %to 10;

%end;

%mend;

% SRTDT(BGNDTE=xxxxxxx);

ENDRSUBMIT;

Thank you!

Re: Is it advisable to write macros within RSUBMIT & ENDRSUBMIT?

Tom — Wed, 13 Apr 2022 03:26:07 GMT

You can, but be sure to test them. In the past I have had issues with the chunking used to send the blocks of code from the local to the remote machine causing issues for the parsing required to compile macros. In one case just inserting a couple of extra characters into a comment caused the macro to work again.

Instead compile the macro on the remote machine from a file on the remove machine.

rsubmit;
%include 'mymacro.sas' ;
%mymacro()
endrsubmit;

If the file only lives on the local machine you can use PROC UPLOAD to copy it to the remote machine first.

rsubmit;
filename mymacro temp;
proc upload infile='mymacro.sas' outfile=mymacro; 
run;
%include mymacro;
%mymacro()
endrsubmit;

Re: Is it advisable to write macros within RSUBMIT & ENDRSUBMIT?

Santt0sh — Wed, 13 Apr 2022 04:18:11 GMT

Hi Tom,

Thank you for your quick response!
I will try to follow, what you have suggested.

Regards