topic Re: Get zip files from website and importing them into SAS in SAS Studio

Get zip files from website and importing them into SAS

mjcm0030 — Tue, 02 Oct 2018 17:42:21 GMT

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!!

Re: Get zip files from website and importing them into SAS

alexal — Tue, 02 Oct 2018 17:58:01 GMT

@mjcm0030,

Here are useful links for you:

Also, just in case:

S3 Procedure

Re: Get zip files from website and importing them into SAS

Reeza — Tue, 02 Oct 2018 18:21:16 GMT

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-sas/

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!!