topic Save a panda dataframe in sas7bdat on sas server in Developers

Save a panda dataframe in sas7bdat on sas server

DelvidioNeto — Wed, 17 Jan 2024 18:47:07 GMT

Hi!
I'm creating an ETL - SQL Server for SAS with python, but my output is a panda dataframe, which I'm not able to convert to sas7bdat with saspy.

I'm using this function:

saspy.dataframe2sasdata(df='mydf',
table="my_clients",
libref='my_lib',
datetimes={'dt_client ' : 'DATE9.'},
outfmts={'id':'11.','payment':'BEST.'}
)

But return a error: AttributeError: 'str' object has no attribute 'columns'

Is this function correct for what I need?

sbxkoenk — Wed, 17 Jan 2024 21:55:58 GMT

Cannot help you right away 🙁 .

But have a look here (saspy-resources😞

https://sassoftware.github.io/saspy/getting-started.html
saspy-examples gityhub repo: https://github.com/sassoftware/saspy-examples
Usage Note 64755: How to create a SAS® session to your SAS® server while using SASPy on Windows with Anaconda
https://support.sas.com/kb/64/755.html

Koen