topic Re: x or %sysexec command in SAS Procedures

x or %sysexec command

makset — Wed, 10 Sep 2014 13:15:37 GMT

Hello

I have a question about the x or %sysexec command options .

Is possible to use these commands so as not appeared cmd window?

I use them in batch sessions very often, and they hinder my work.

Thank you for your help.

Re: x or %sysexec command

Reeza — Wed, 10 Sep 2014 13:35:00 GMT

Try

options noxwait ;

SAS(R) 9.2 Companion for Windows, Second Edition

Re: x or %sysexec command

makset — Wed, 10 Sep 2014 13:43:56 GMT

XWAIT

means that the command prompt session waits for you to type EXIT before you can return to your SAS session.

not work

Re: x or %sysexec command

Tom — Wed, 10 Sep 2014 13:53:29 GMT

I would suggest replacing any X commands with data _null_ steps instead. For %SYSEXEC() you might need to check what else the program is doing as it might not be an appropriate place to introduce a step boundary.

Replace

x echo hello ;

With

data _null_;

infile "echo hello" pipe;

input;

put _infile_;

run;

Re: x or %sysexec command

makset — Wed, 10 Sep 2014 15:19:52 GMT

In simple commands work, but I have this:

%let log = -log "&CodePatch"; or %let log = -nolog;

%sysexec start /high sas.exe -icon -noterminal -nosplash -noxwait -noxsync -CONFIG

"C:\Program Files\SAS\SASFoundation\9.2\SASV9.CFG" -SYSIN "&CodePatch._GlobalControl_1.sas" &log;

Re: x or %sysexec command

Tom — Wed, 10 Sep 2014 15:23:15 GMT

Use the quote() function.

%let command=any valid command with any type of quoting ;

data _null_;

infile %sysfunc(quote(&command)) pipe;

input;

put _infile_;

run;

Re: x or %sysexec command

makset — Wed, 10 Sep 2014 15:51:58 GMT

Is perhaps still some other option? because thus, locks the session SAS

Session which calls your command runs until the end of session induced.

Re: x or %sysexec command

Reeza — Wed, 10 Sep 2014 15:58:15 GMT

I don't think we understand your question. Can you be more explicit please?

Re: x or %sysexec command

Tom — Wed, 10 Sep 2014 16:03:00 GMT

If you are trying to use this to run an asynchronous process then data _null_ step is NOT what you want.

To your original question you probably want to set the option NOXWAIT to prevent leaving the command window open. You might also look at NOXSYNC.

http://support.sas.com/documentation/cdl/en/hostwin/63285/HTML/default/viewer.htm#exittemp.htm

Also did you try the SYSTASK command instead?

http://support.sas.com/documentation/cdl/en/hostwin/63285/HTML/default/viewer.htm#win-stmt-systask.htm

Re: x or %sysexec command

jakarman — Wed, 10 Sep 2014 17:05:32 GMT

Do you search for adding the -nodms option for the batch script so the dms system will not come SAS(R) 9.3 System Options: Reference, Second Edition

Re: x or %sysexec command

SassyJohn — Tue, 24 Feb 2015 18:55:27 GMT

Tom,

I am looking at the %CMS command which is similar to the x command and I am having difficulties getting started. I am trying to pull data from AVAYA cms and don't know how to write the code nor can I find documentation. Do you have any idea how the code might look?

Thanks

Re: x or %sysexec command

yhz — Tue, 24 Feb 2015 19:24:25 GMT

If you want to run batch job without the cmd window or DOS window poping up, add the following option on top of SAS code:

options noxwait;

Re: x or %sysexec command

Tom — Tue, 24 Feb 2015 20:39:02 GMT

I haven't used an IBM machine running VM/CMS since we migrated to OS/2.

Re: x or %sysexec command

jakarman — Tue, 24 Feb 2015 20:51:24 GMT

The CMS is an oldy: Statements : CMS (v8 and esa/cms dedicated). A shell escape for interactive typing is not well accepted these days

You have to decide what you are needing.

a/ only a start of some program without any feedback on the results (asynchroon processin) tha using noxwait

b/ starting a program and needing the results/feedback than use the pipe approach.

c/ some system are support a proo setup for calling programs.

As you are trying to pull data form AVAYA CMS start at that side finding the technical description of that product retrieving data.

Re: x or %sysexec command

Sushil_rsk — Mon, 12 Feb 2018 16:51:05 GMT

You can use "options noxwait;"

Put this in before you start %sysexec.

This will help you get rid of keying in "EXIT" in the command prompt every time.