topic Re: Access Files from FTP in SAS Data Management

Access Files from FTP

BMI0776 — Wed, 02 Jul 2014 15:32:56 GMT

I apologize of asking a question that has probably already been asked, but i couldn't find an answer. .

How can I download a file, save it to a known location, and unzip the file to be imported by SAS? I am not using SAS on Unix. I have seen quite a few answers for a UNIX environment.

Thanks in advance for your help.

Re: Access Files from FTP

jakarman — Wed, 02 Jul 2014 17:00:02 GMT

As you are probably on Windows the Unix solutions you have found are not really different your question is also not. What is your problem? Using 7zip.exe at your solution?

Re: Access Files from FTP

BMI0776 — Wed, 02 Jul 2014 17:54:32 GMT

I'll calrify my question. I would like to do the following in SAS 9.2

1) How do i download a file from an FTP and save it to a know location

2) How do I unzip the file I just downloadd

THanks

Re: Access Files from FTP

jakarman — Wed, 02 Jul 2014 18:16:34 GMT

SAS has a ftp interface it is rather limited but when working you could use that.

When you need to use an other (s)ftp application you are getting dependent on scripting and the x-cmd.

SAS is using zip files, with ods you can use some actions on zip files. Needing an other zip application being used you are getting dependent on scripting and the x-cmd interface.

All is becoming better with the newest releases of SAS just do the upgrade (no additional license cost).

Re: Access Files from FTP

Tom — Wed, 02 Jul 2014 18:31:03 GMT

Look at this thread for discussion of using 7za.exe command program for dealing with ZIP files on Windows machines.