SAS EG connection to unix mysql server

[Fox_3]

Guys, I need to create a connection from my  local server i.e in Windows OS to  Unix my sql server.

I need to transfer my sas datsets which is in local server1.e  windows os to unix mysql server.

[Doc_Duke]

I don't know MySQL, but I often simply FTP SAS datasets from one platform to another.  SAS is generally able to use its cross-platform tools to read them.

If you have a more specific question about the transfer, maybe you could re-frame the question.  Are you asking about doing it within the EGuide context?

[Kurt_Bremser]

Several ways, depending on your setup.

If you want to do it directly, you need to have SAS/ACCESS to MySQL licensed, either on Windows (if your Base SAS/Foundation is on your desktop) or on UNIX (if Base SAS/Foundation is installed there). You also need to set up the connection to the database (usually involves installation/setup of the dbms client that SAS/ACCESS will then use).

Or you can export the data from SAS to a suitably formatted flat file that the DBMS can then import.