topic Re: Execute Python code within SAS Enterprise Guide in SAS Programming

Execute Python code within SAS Enterprise Guide

Vemula — Wed, 19 Oct 2022 08:11:46 GMT

Hi all,

I am using SAS Enterprise Guide to execute Python code. We have SAS 9.4M6. I have used below ways but are unsuccessful. Could you please help me with it?

Python Code:

import tempfile

import errno

def isWritable(path😞

try:

testfile = tempfile.TemporaryFile(dir = path)

testfile.close()

except OSError as e:

if e.errno == errno.EACCES: # 13

return False

e.filename = path

raise

return True

print(isWritable("/path/project"))

proc fcmp;
declare object py(python);
rc = py.infile("/path/get_d_list.py");
put rc=;
rc = py.publish();
rc = py.call("isWritable", "/path/vyashoda");
/* Result = py.results["MyOutputKey"];*/
/* put Result=;*/
run;

x "python3 /path/get_d_list.py";

3:
data _null_;
call system ('python3 /path/get_d_list.py');
run;

%macro pwdls;
%sysexec %str(pwd;python3 /path/get_d_list.py);
%mend pwdls;
%pwdls;

Re: Execute Python code within SAS Enterprise Guide

ChrisNZ — Fri, 21 Oct 2022 00:43:23 GMT

I never used python in SAS, but you should use

filename CMD pipe 'python3 /path/get_d_list.py 2>&1';
data _null_;

infile CMD;

input;

put _infile_;
run;

instead of

data _null_;
call system ('python3 /path/get_d_list.py');
run;

to see OS messages.

Re: Execute Python code within SAS Enterprise Guide

Vemula — Fri, 21 Oct 2022 10:33:25 GMT

Thanks much Chris for your help. Appreciate it. It's working for me.