saspy - Execute SAS from Python

MariaD — Wed, 23 Aug 2023 14:54:44 GMT

Hi folks,

We have a SAS code that makes some data transformation creating multiple tables on WORK library. The code works perfectly. The SAS code is something like below example:

data tmp;
  set seashelp.class;
run;

data tmp2;
  set tmp;
 ....;
run;

data tmp3;
  set tmp2;
 ....;
run;

data tmp4;
  set tmp3;
 ....;
run;

We tried to execute the same code on Python, using the following code and tried to describe the last table created on it (all the tables are created on WORK libname) but an error appears. The error says that the table does not exists. If we tried to describe the first table created on WORK, appear without any problem.

codigo = open('c:\xxxx\my_code.sas').read()

sas.submit(codigo)

table_sas = sas.sasdata("WORK", "TMP4")
table_sas.describe()

Is any limitation of using WORK to process using saspy?

Regards,

Re: saspy - Execute SAS from Python

JosvanderVelden — Thu, 24 Aug 2023 09:17:46 GMT

Can you try to run with the same code using work.tmp in stead of just tmp?
Does that resolve the issue?

Re: saspy - Execute SAS from Python

MariaD — Thu, 24 Aug 2023 13:48:54 GMT

Thanks! Added the WORK as indicated and now works fine.

Regards,

topic saspy - Execute SAS from Python in SAS Data Science

saspy - Execute SAS from Python

Re: saspy - Execute SAS from Python

Re: saspy - Execute SAS from Python