Date Added: Oct 2009
SAS and Excel are two of the most useful tools in processing, analyzing, and reporting data, with each of them having its own strength and often a distinct user group. For example, SAS is one of the most powerful tools for data merging, cleansing, coding, and statistical analysis; however, it is not an ideal tool for certain kinds of reporting described in this paper. Excel, on the other hand, is the most widely used business tool for data analysis and reporting and has strong graphing and formatting facilities; however, its capability for processing large data sets and statistical analyses is limited. This paper explores ways to integrate the two applications and take advantage of their strength.