I recently wrote a paper on automating SAS using VBScript. I wanted to share this here, as it has dozens of applications.
VBScript and SAS are each powerful tools in their own right. These two technologies can be combined so that SAS code can call a VBScript program or vice versa. This gives a programmer the ability to automate SAS tasks, traverse the file system, send emails programmatically, manipulate Microsoft® Word, Excel, and PowerPoint files, get web data, and more. This paper presents example code to demonstrate each of these capabilities.
If you like it, please check out my other papers, downloads, and subscribe to my free bimonthly e-magazine.