%SPARKY: A SAS® Macro for Creating Excel Sparklines

From sasCommunity
Jump to: navigation, search

Abstract

Think big? No, think small! Characterized by their small size and high data density, sparklines are information graphics that present trends and variations associated with data in a simple and condensed way. This paper describes %SPARKY, a SAS® macro that creates cell-sized sparklines for embedding in Excel worksheets. This technique might be of interest to all skill levels. It uses Base SAS®, SAS/GRAPH®, the SAS® Macro Facility, Excel, and Visual Basic for Applications (VBA) on the PC platform.

Online Materials