I like to think of the DATA step as the multi-tool in my programmer’s toolkit. And with the FILENAME “add-on”, it becomes the deluxe version, adding an incredible amount of additional functionality to our programs. This presentation focused on the amazing versatility of the Base SAS FILENAME statement.
Working directly with remote files without downloading a local copy, including:
Reading raw data files located on a remote FTP server
Open and read a text file from a URL pointing to a web server
Using PROC HTTP to quickly download local copies of internet files
Reading from and writing to files in a ZIP archive
Programmatically unpacking a ZIP file to the local file system
Sending email from a SAS program
The attached ZIP file a PDF of the presentation and all of the data and code used to create it.