topic Re: SAS Macro Remote Submit Complete Instantly Without Even Running It in SAS Programming

SAS Macro Remote Submit Complete Instantly Without Even Running It

newboy1218 — Tue, 02 Jul 2019 20:50:40 GMT

Hi.. I am trying to remote submit the following SAS code but the log returns 'remote submit complete' without even running it.. Anyone knows what is wrong with my code?

Here is the log message:

NOTE: Remote submit to commencing.
381 %extract(d1 = 01MAY2019, d2 = 31JUL2019);
NOTE: Remote submit to complete.

rsubmit;
%macro extract(d1=, d2=);
%let start_date = &d1.;
%let end_date = &d2.;

%let i = 1;
%let dt1 = &start_date.;

%do %while ("&dt1."d <= "&end_date."d);
	%let dt1 = %sysfunc(putn("&dt1."d, date9.));

	%let dt2 = &dt1.;
	%let dt2 = %sysfunc(putn("&dt1."d, yymmddn8.));

	%let dt3 = %sysfunc(intnx(day, "&dt1."d, -1, s), date9.);

	%if %sysfunc(exist(prod.Tdaf_var_nonprime_&dt2.)) %then %do;
		data dataset_&dt2.;
        	set prod.dataset_&dt2. (obs = 10);
    	run;
	%let dt1 = %sysfunc(intnx(day, "&dt1."d, 1, s), date9.);
	%let i = %eval(&i. + 1);

	%end;

	%else %let dt1 = %sysfunc(intnx(day, "&dt1."d, 1, s), date9.);

%end;

%let m = %eval(&i. - 1);

%mend;
endrsubmit;

rsubmit;
%extract(d1 = 01MAY2019, d2 = 31JUL2019);
endrsubmit;

Re: SAS Macro Remote Submit Complete Instantly Without Even Running It

Reeza — Tue, 02 Jul 2019 20:59:56 GMT

Do the macro submission and call in the same rsubmit block and see what happens.

@newboy1218 wrote:

Hi.. I am trying to remote submit the following SAS code but the log returns 'remote submit complete' without even running it.. Anyone knows what is wrong with my code?

Here is the log message:

NOTE: Remote submit to commencing.
381 %extract(d1 = 01MAY2019, d2 = 31JUL2019);
NOTE: Remote submit to complete.

rsubmit;
%macro extract(d1=, d2=);
%let start_date = &d1.;
%let end_date = &d2.;

%let i = 1;
%let dt1 = &start_date.;

%do %while ("&dt1."d <= "&end_date."d);
	%let dt1 = %sysfunc(putn("&dt1."d, date9.));

	%let dt2 = &dt1.;
	%let dt2 = %sysfunc(putn("&dt1."d, yymmddn8.));

	%let dt3 = %sysfunc(intnx(day, "&dt1."d, -1, s), date9.);

	%if %sysfunc(exist(prod.Tdaf_var_nonprime_&dt2.)) %then %do;
		data dataset_&dt2.;
        	set prod.dataset_&dt2. (obs = 10);
    	run;
	%let dt1 = %sysfunc(intnx(day, "&dt1."d, 1, s), date9.);
	%let i = %eval(&i. + 1);

	%end;

	%else %let dt1 = %sysfunc(intnx(day, "&dt1."d, 1, s), date9.);

%end;

%let m = %eval(&i. - 1);

%mend;
endrsubmit;

rsubmit;
%extract(d1 = 01MAY2019, d2 = 31JUL2019);
endrsubmit;

Re: SAS Macro Remote Submit Complete Instantly Without Even Running It

newboy1218 — Tue, 02 Jul 2019 20:54:43 GMT

Same result, it did not run through..

Re: SAS Macro Remote Submit Complete Instantly Without Even Running It

Reeza — Tue, 02 Jul 2019 20:59:40 GMT

Are you sure? Where are you looking for the results, in the remote work library right? I'm assuming you're connected to that somehow?

Re: SAS Macro Remote Submit Complete Instantly Without Even Running It

Tom — Tue, 02 Jul 2019 21:02:33 GMT

Are you sure

prod.Tdaf_var_nonprime_&dt2.

exists?

If the libref PROD even defined?

Re: SAS Macro Remote Submit Complete Instantly Without Even Running It

newboy1218 — Tue, 02 Jul 2019 21:01:36 GMT

yeah there is nothing created in my remote work library.

Re: SAS Macro Remote Submit Complete Instantly Without Even Running It

newboy1218 — Tue, 02 Jul 2019 21:04:23 GMT

yes. plus, if it doesn't exit, it will execute the 'else do' step.

Re: SAS Macro Remote Submit Complete Instantly Without Even Running It

Tom — Tue, 02 Jul 2019 21:04:24 GMT

How did you get explorer to show you a list of files for a libref defined in a remote session?

Re: SAS Macro Remote Submit Complete Instantly Without Even Running It

newboy1218 — Tue, 02 Jul 2019 21:06:03 GMT

like this?

rsubmit;
libname prod 'xxxxxxxxxxxxxxxxxxxxxxx'; 
endrsubmit;

libname prod server=&rsession;

Re: SAS Macro Remote Submit Complete Instantly Without Even Running It

Reeza — Tue, 02 Jul 2019 21:09:51 GMT

First option here is usually what I use to separate the remote from local.
http://support.sas.com/kb/24/836.html

OP, data set is being written to the remote WORK library, not the PROD library.

Re: SAS Macro Remote Submit Complete Instantly Without Even Running It

Reeza — Tue, 02 Jul 2019 21:10:32 GMT

At this point I'd probably restart and see if it works or not.

Re: SAS Macro Remote Submit Complete Instantly Without Even Running It

Astounding — Tue, 02 Jul 2019 23:37:52 GMT

I doubt that macro language can compute this comparison properly:

%do %while ("&dt1."d <= "&end_date."d);

Try it this way:

%do %while (%sysevalf("&dt1."d <= "&end_date."d));

Re: SAS Macro Remote Submit Complete Instantly Without Even Running It

newboy1218 — Wed, 03 Jul 2019 12:49:13 GMT

I think it works now! Thank you!!