Get zip files from website and importing them into SAS

[mjcm0030]

Hi, I'm new to SAS and I'm wondering how could I download a set of datasets in zips from a website, and then importing them to SAS.

The website is https://s3.amazonaws.com/tripdata/index.html, and can be access like:
                      https://s3.amazonaws.com/tripdata/ + id of every file (example, 201306-citibike-tripdata.zip) and always repeats the name

Here, i have the code I'm using, but it only gets 1 zip, decompress, and import into a table. I want it to do it with every file.

Thank you!!

[alexal]

@mjcm0030,

Here are useful links for you:

• PROC HTTP
• FILENAME Statement, URL Access Method
• FILENAME Statement, ZIP Access Method

Also, just in case:

• S3 Procedure

[Reeza]

You most definitely can do this, but you may need a loop or macro. 

Here's an example of how to get the list of files and to access them:

https://blogs.sas.com/content/sasdummy/2015/05/11/using-filename-zip-to-unzip-and-read-data-files-in...

Basically, get it working for one file then convert that to a macro. Use methods above to get all files listed and then call the macro once for each file.

---

@mjcm0030 wrote:

Hi, I'm new to SAS and I'm wondering how could I download a set of datasets in zips from a website, and then importing them to SAS.

The website is https://s3.amazonaws.com/tripdata/index.html, and can be access like:
                      https://s3.amazonaws.com/tripdata/ + id of every file (example, 201306-citibike-tripdata.zip) and always repeats the name

Here, i have the code I'm using, but it only gets 1 zip, decompress, and import into a table. I want it to do it with every file.

Thank you!!

---