topic Re: VBScript Executes Successfully in SAS Base, But Fails in Batch Mode Without Errors in SAS Programming

VBScript Executes Successfully in SAS Base, But Fails in Batch Mode Without Errors

laika_matias — Thu, 18 Apr 2024 11:20:53 GMT

VBScript runs successfully when executed from SAS Base, but doesn't work in batch mode (I cannot see any errors).

DATA _NULL_;
RC=SLEEP(5);
RUN;

option noxwait;
option noxsync ;
data _NULL_;
rc1=system('path\copy_cal.vbs');
put rc1;
run;

DATA _NULL_;
RC=SLEEP(5);
RUN;

Re: VBScript Executes Successfully in SAS Base, But Fails in Batch Mode Without Errors

SASKiwi — Thu, 18 Apr 2024 21:25:12 GMT

Check the XCMD SAS system option in batch mode to confirm if SAS will let you execute commands in the OS or not:

proc options option = xcmd;
run;

Re: VBScript Executes Successfully in SAS Base, But Fails in Batch Mode Without Errors

laika_matias — Fri, 19 Apr 2024 10:10:13 GMT

Thank you for your response! 🙂 I have checked the XCMD SAS system option in batch mode, and it shows that it is enabled. There are no errors in the log, and everything appears to be working fine. However, the VBScript code still does not seem to execute.

XCMD              Enables the X command in SAS.
NOTE: PROCEDURE OPTIONS used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds

65
66         option noxwait nosyntaxcheck;
67         option noxsync ;
68
69         data _NULL_;
70         rc1=system('G:\path\script.vbs');
71         put rc1;
72         run;

0
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds

73
74         proc options option=xcmd;
75         run;

    SAS (r) Program 9.4 TS1M3

XCMD              Enables the X command in SAS.
NOTE: PROCEDURE OPTIONS used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds

Re: VBScript Executes Successfully in SAS Base, But Fails in Batch Mode Without Errors

Patrick — Fri, 19 Apr 2024 11:49:13 GMT

Just as a thought: The vbs script executes as a child process of your parent SAS session. When running in batch and the parent SAS session terminates the child session will get killed if not finished already.

To test the theory: Use options XWAIT and XSYNC and see if this changes things.

Re: VBScript Executes Successfully in SAS Base, But Fails in Batch Mode Without Errors

laika_matias — Fri, 19 Apr 2024 12:04:59 GMT

Thank you! but I already have those options added 😕

Re: VBScript Executes Successfully in SAS Base, But Fails in Batch Mode Without Errors

Patrick — Fri, 19 Apr 2024 12:48:03 GMT

@laika_matias wrote:

Thank you! but I already have those options added 😕

So the SAS log you shared with us is not what you executed? As in the log it's NOxwait and NOxsync

Re: VBScript Executes Successfully in SAS Base, But Fails in Batch Mode Without Errors

laika_matias — Fri, 19 Apr 2024 13:11:44 GMT

I've just tried to execute the code according to the options you provided, but still nothing 😕

Re: VBScript Executes Successfully in SAS Base, But Fails in Batch Mode Without Errors

laika_matias — Fri, 19 Apr 2024 13:23:12 GMT

It seems that the 'xwait' option is causing the SAS application to hang while executing its task.

Re: VBScript Executes Successfully in SAS Base, But Fails in Batch Mode Without Errors

Quentin — Fri, 19 Apr 2024 16:10:59 GMT

What OS are you running on?

Maybe just to separate the SAS stuff from the VBS script try just running a single command, like:

options noxwait xsync ;
data _NULL_;
rc1=system('/*run some command here to make a directory or a file*/');
put rc1;
run;

You also might try using SYSTASK, something like:

systask command "/*your command here*/" status=mystatus wait shell;  
%put &=mystatus &=sysrc; *both should be 0 if success;

Re: VBScript Executes Successfully in SAS Base, But Fails in Batch Mode Without Errors

data_null__ — Fri, 19 Apr 2024 16:19:13 GMT

What exactly does "when executed from SAS Base" mean?

@laika_matias wrote:

VBScript runs successfully when executed from SAS Base, but doesn't work in batch mode (I cannot see any errors).

DATA _NULL_;
RC=SLEEP(5);
RUN;

option noxwait;
option noxsync ;
data _NULL_;
rc1=system('path\copy_cal.vbs');
put rc1;
run;

DATA _NULL_;
RC=SLEEP(5);
RUN;