To replace sas by python in companies


#1

Hello,

how to use Python in company?
In company I use SAS and I manipulate the server data in Sas language with “proc Sql”.

How does a company make the server link python and how to handle table on a server quickly? thank you in advance


#2

@fred0715,

Can you elaborate on what you mean by a server? How do you connect SAS with this server? Is it a SQL server or some other server?


#3

It seems to me that this is a sql server. Thank you for taking the time to answer me


#4

@fred0715,

Here is one link for that - http://www.w3resource.com/mysql/mysql-python-connection.php


#5

It depends on your database technology, python has different connectors for them. You could use PYODBC as well, just need to set your parameters right. In my case, we use HP Vertica and Uber has a ‘vertica-python’ module which is what I use.