Home

Welcome to my SAS macro program repository! The best way to explore the macros available here is to search the site or review the categories.

The macros on this site were developed using Base SAS 9.1.3, Base SAS 9.2, and SAS Enterprise Guide 9.3 on Windows. Many may work on non-Windows platforms. Before using any macro in production, please review the code, check for dependencies, and test the macro for compatibility within your system.

Feel free to contact me [External] if you have any questions or feedback regarding these macros.

Documentation

• Arguments: The header of each macro contains a list of arguments and a short description of the argument. Additionally, most arguments are validated as required, specific values, or criteria specific to the macro.
• Documentation: Notes on some of the macros regarding the reasons behind the process.
• Headers: Each macro contains a standard header section with metadata, including author, creation date, purpose, revisions, and arguments.
• Feedback [External]: Feel free to send me feedback, comments, questions, or even macro revisions!

Categories

• Arcane Code
• Code Generation
• Code Helpers
• Data Quality
• Fun
• Functions
• Interactive
• Macro Variable Manipulation
• Special Requests
• Stored Processes

CheckLog

• Introduction
  • Dependencies
  • Features
  • Issues Identified
  • Issues Ignored
  • References
• CheckLog Documentation
  • Arguments
  • Example Usage
  • Example Issues
  • Enterprise Guide

SAS Global Forum 2012

I wrote two papers for the SAS Global Forum in 2012. Here are the links to the full papers as well as links to the code documetation.

• An Advanced, Multi-Featured Macro Program for Reviewing Logs (Full Paper [External])
  • CheckLog Introduction
• Standardized Macro Programs for Macro Variable Manipulation (Full Paper [External])
  • Documentation
  • Examples
  • Demonstration

User Feedback

The following feedback was sent by users.

My co-worker and I have been reviewing your CheckLog.sas script with great interest. It is by far the most advanced and well-documented SAS script I ever came across. We are especially impressed by your constant efforts in maintaining and improving the script.

Hung Tam Nguyen, Principal Analyst, Models and Risk Measures, Laurentian Bank of Canada

I just wanted to thank you for all the great code you provide. In particular, the CheckLog macro and its supporting VB scripts reliably report on a dozen automated ETL processes that our agency depends on. All your extra effort making the macro versatile, robust, and well documented enabled someone with absolutely no macro language experience (me), to successfully implement CheckLog.

Nathan Champlin, SAS Intelligence Platform Administrator, Bureau of Automotive Repair of California

I have used your CheckLog macro during my time at university and it has been very beneficial ensuring my program logs are clean, so thank you very much for that! I have found the macro highly useful and has enabled me to produce accurate results with clean logs during my time at Phastar. I have also learnt some tips and tricks by having read through the code which has helped me further develop my SAS programming skills, having only had basic understanding. Thank you so much!"

Ruhel Hussain, Statistical Programmer