03-28-2016 07:44 AM
03-28-2016 08:00 AM
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.
03-28-2016 08:05 AM
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.
03-28-2016 10:51 PM - edited 03-28-2016 10:52 PM
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.