SAS EG is in Unix Server and Data files are located in Linux server. Connect two servers

[Karthick]

I have SAS EG installed and connect to remote server which is in Unix platform. I also have a different remove server which is in Linux platform. The Linux server has some secure data files which i need to pass command through SAS EG to load these files. my questions, right now the SAS EG is connected to only remote server which in Unix platform. how to connect the other remote server which is Linux? Currently I'm using Putty and Filezila to transfer the files. Any one have a suggestion how to do it.

[ChrisHemedinger]

You could use the FILENAME FTP method to connect from your SAS session to the remote Linux server, as long as there is a running ftp daemon (usually there is).  See the doc for the FILENAME FTP method.

Depending on the type of file, you might need to use a DATA step method to make a copy of the file in your SAS session before you can use it -- or you might be able to stream the contents into your SAS program for immediate use.

[Karthick]

In detail, I'm try to set up a process through SAS EG for data loading process in Netezza. Currently we are using nzload in Putty to load the data file (which is in Linux server). There is more manual process. So if I'm able to access the Linux server using SAS EG then I can set a process.

I will look into the FILENAME FTP access method.

Please let me know if you have any other suggestions. 

[jimbarbour]

Karthick,

Another thing you might check into is drive mappings.  In my shop, we have both UNIX (AIX) and LINUX servers, just as you do, but our drives are mapped such that many of the LINUX drives (which have data) can be read by the UNIX machine (which has SAS).

Barring that, there are ways to write things like BASH scripts to automate file transfers.  We're using lftp on our UNIX server.  It's a little obscure, but not that bad.  You might check and see what is available to you in your installation, and then Google that product's name for examples of how to use it.

Jim