Can't pass data sets from Python to SAS through SASpy

hussier1 — Tue, 09 Jul 2024 12:22:21 GMT

I installed and configured Saspy in my Python Jupyter notebook yesterday, and it seemed to work well. Today, I added this code, but the SAS log tells me that the sasMSE dataset cannot be found. Furthermore, the code I wrote yesterday which worked well yesterday (and I didn't change that code at all today), where I tried to convert a CSV file to a SAS dataset, also has the same error today: the dataset cannot be found.

I suspect there must be some issue with my connection to SAS, but I can't tell that there's anything wrong at first glance.

dfMSE=pd.DataFrame(MSE)
sasMSE=sas.df2sd(dfMSE, 'cfc')

msesascode="""

data sasMSE;
set sasMSE;
MSE='0';
Breakpoint=_N_;

PROC gplot
data=sasMSE;
plot MSE*Breakpoint;
run;
"""

sas.submitLST(msesascode)

Re: Can't pass data sets from Python to SAS through SASpy

Tom — Tue, 09 Jul 2024 13:04:27 GMT

Did the step to create the SAS dataset work? Does Python report any errors when you run that step?

Did the SAS code run? What does the SAS log returned by SAS look like? I would be surprised if it ran since it looks to me like you are trying to use a SAS dataset you never created. Shouldn't the name of the SAS dataset be the second argument you passed to the df2ds() function?

topic Can't pass data sets from Python to SAS through SASpy in SAS Programming

Can't pass data sets from Python to SAS through SASpy

Re: Can't pass data sets from Python to SAS through SASpy