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!!
Here are useful links for you:
Also, just in case:
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:
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!!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: