Access Files from FTP

[BMI0776]

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.

[jakarman]

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?

[BMI0776]

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

[jakarman]

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).

[Tom]

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