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;
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. ?
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. ?
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.