The ubiquity of Microsoft Excel in office settings makes Excel a commonly used format for SAS output. While SAS features many ways to export data into Excel, the output consists of hard-coded values. What options are there when clients or supervisors want to see the formulas that underlie the exported values? While the analyst can manually construct the formulas in Excel following the export of data, there are circumstances where the quantity or complexity of the formulas make this a tedious endeavor. The good news is that SAS offers some solutions to this dilemma. This paper details some of the ways that the analyst can create formulas in SAS and export them directly into Excel, from the use of ODS style attributes for basic formulas to the use of a dynamic framework for complex formulas involving multiple variables.
conference:
Paper Type:
Paper
