Using Macro Variable Lists to Create Dynamic Data-Driven Programs - Josh Horstman, Nested Loop Consulting

The SAS Macro Facility is an amazing tool for creating dynamic, flexible, reusable programs that can automatically adapt to change. In this paper, you'll see how macro variable lists provide a simple but powerful mechanism for creating data-driven programming logic. Don't hard-code data values into your programs. Eliminate data dependencies forever and let the macro facility write your SAS code for you!

Click here to download the companion paper.

Creating and Customizing High-Impact Excel Workbooks from SAS with ODS EXCEL - Josh Horstman, Nested Loop Consulting

Love it or hate it, Microsoft Excel is used extensively throughout the business world. As a SAS user, you can enhance the impact of your work by using the ODS EXCEL destination to create high-quality, customized output in Excel format directly from SAS. This presentation walks through a series of examples demonstrating the flexibility and power of this approach. In addition to complete control over visual attributes such as fonts, colors, and borders, the ODS EXCEL destination allows the SAS user to take advantage of Excel features such as multiple tabs, frozen or hidden rows and columns, and even Excel formulas to deliver the high-impact results you and your customers want!

Click here to download the companion paper.

About the Author

Josh Horstman is an independent statistical programmer based in Indianapolis with over 25 years’ experience using SAS in the life sciences industry. He specializes in analyzing clinical trial data, and his clients have included major pharmaceutical corporations, biotech companies, and research organizations.

A SAS Certified Advanced Programmer, Josh loves coding and is a frequent presenter and trainer at SAS Global Forum and various regional and local SAS user groups. Josh holds a bachelor's degree in mathematics and computer science, and a master's degree in statistics from Colorado State University.