topic Re: Run python command with systask in SAS Enterprise Guide

Run python command with systask

atux — Mon, 30 Nov 2020 16:58:15 GMT

I am trying to execute a python script in SAS using the systask command. I am using the systask over the x command so I can get the error return code when there is a problem. I am able to get the desired results when I run the following in a command prompt:

d:temp\python\getdata.py -c 9999 -l 000 -start 11/01/2020 -base 9999-000.

When I run the following in enterprise guide I get an error code of 1 and the python command does not execute:

systask command "d:\temp\python\getdata.py. -c 9999. -l &location. -start &startdate. -base 9999-000"
wait
status=RC_getdataCSV
shell;

data _null_;
if &RC_getdataCSV>0 or &sysrc>0 then do;
put 'ERROR Occurred Pulling data';
end;
else put 'NOTE: Run completed successfully';
run;

Re: Run python command with systask

Reeza — Mon, 30 Nov 2020 17:25:00 GMT

Is EG running locally to have the same access to the D drive? Or is it running on a server somewhere that D access may not be available?

Re: Run python command with systask

Tom — Mon, 30 Nov 2020 17:30:07 GMT

Use PIPE. You might not get an error code, but you can read the messages that the command sends to the console.

data _null_;
  infile "d:\temp\python\getdata.py. -c 9999. -l  &location. -start &startdate. -base 9999-000 2>&1" pipe ;
  input;
  put _infile_;
run;

PS Do you really have a filename with two periods in it? getdata.py. ?