Running complex external system command from SAS / SCL

[Nieumysl]

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?

[JakobHommelhoff]

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

[Nieumysl]

Thanks Jakob! 🙂 It works swimmingly :smileygrin: