12-11-2014 01:34 AM
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.
12-11-2014 04:18 PM
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?
12-12-2014 02:25 AM
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.