Save a panda dataframe in sas7bdat on sas server

[DelvidioNeto]

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]

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