topic Running complex external system command from SAS / SCL in SAS Programming

Running complex external system command from SAS / SCL

Nieumysl — Thu, 18 Sep 2014 06:31:41 GMT

Hi,

I'm trying to run this windows cmd instruction from SAS (when executed from cmd, it works perfectly fine) :

for /f "usebackq tokens=2*" %i in (`svn st ^| findstr /R "^!"`) do svn del "%i"

Now, tried everything: x, system from scl, quotations... nothing works - the issue seems to be the variables, which get interpreted as macro definitions, but there seems to be no way around that... Can anybody help me with that?

Re: Running complex external system command from SAS / SCL

JakobHommelhoff — Thu, 18 Sep 2014 08:02:21 GMT

Hi Nieumysl

Have you tried this approach:

filename cmd pipe "<your cmmand>" lrecl=2048;

data _null_;

infile cmd;

input;

put _infile_;

run;

The benefit here is that you can see the command-prompt messages in the sas-log.

Another approach that might be helpful is to write the command to a .bat or .cmd file.

and call the the bat/cmd from SAS in whatever way.

Br, Jakob Hommelhoff

Re: Running complex external system command from SAS / SCL

Nieumysl — Thu, 18 Sep 2014 10:40:17 GMT

Thanks Jakob! 🙂 It works swimmingly :smileygrin: