saspy - Execute SAS from Python

[MariaD]

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, 

[JosvanderVelden · Accepted solution]

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

[MariaD]

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

Regards,