Tips for working with Color Names, Formats, Macros, ODS, Excel®, and PROC REPORT

Not too long ago I had a report generation request from an Alaska state agency. The request had some very specific requirements that detailed the use of user defined colors (by name), data driven control of the report, and Excel delivery using ODS and PROC REPORT. Along the way I had [...]