BookmarkSubscribeRSS Feed
SASJedi
SAS Super FREQ

Abstract

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.

I discussed:

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

Check out my Jedi SAS Tricks for SAS Users