SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Access Files from FTP

Reply
Occasional Contributor
Posts: 11

Access Files from FTP

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.

Trusted Advisor
Posts: 3,211

Re: Access Files from FTP

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?

---->-- ja karman --<-----
Occasional Contributor
Posts: 11

Re: Access Files from FTP

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

Trusted Advisor
Posts: 3,211

Re: Access Files from FTP

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

---->-- ja karman --<-----
Super User
Super User
Posts: 7,039

Re: Access Files from FTP

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

Ask a Question
Discussion stats
  • 4 replies
  • 416 views
  • 0 likes
  • 3 in conversation