Download now Free registration required
The advent of the ODS ExcelXP tagset and its many features has afforded the SAS user great flexibility in creating publishable Excel output. But what if the report must be delivered by populating pre-defined, customized Excel worksheets? DDE has been around for ages, and is a viable option, but often not a simple one to execute. This paper will demonstrate another method, the EXCEL libname engine. Using the EXCEL libname, SAS is able to write data into specific, pre-defined "named ranges" in customized Excel worksheets.
- Format: PDF
- Size: 505.5 KB