Flexible HTML Reporting Using Advanced Macro Programming and TableEditor Tagset
SAS ODS techniques provide the ability to create HTML outputs and help minimize manual work. However, if one still misses dynamic and interactive Excel functionalities, the author has a solution! Now, one can filter, sort and conditional format HTML output just like Microsoft Excel. This paper demonstrates how advanced macro programming techniques and user-defined tagset TableEditor were used to create interactive and efficient HTML reports at RCI, the global leader in timeshare exchange and part of the Wyndham Worldwide family of companies. Advanced macro programming is applied to organize HTML pages and to create a dynamic menu page with hyperlinks. User-defined tagset TableEditor is utilized along with SAS ODS techniques to create Excel like data grids and to perform conditional formatting.