Title: Creating Your Own Worksheet Formats in exportToXL
Abstract: %exportToXL is a freely available SAS R macro which allows the user to create custom-formatted Excel R worksheets, using Dynamic Data Exchange (DDE). It works on all versions of PC Base SAS, Windows, and Excel. Using this macro, the user can create custom-formatted worksheets by either exporting the SAS data onto a pre-formatted Excel worksheet, or by using a worksheet format. This is a set of commands which tells Excel how to format certain aspects of a worksheet such as font sizes and column widths. While %exportToXL comes with a few different pre-programmed worksheet formats, any programmer with some basic knowledge of the SAS macro language and DDE commands can make his/her own. This paper is a tutorial about how to do just that.
Publication Year: 2008
Publication Date: 2008-01-01
Language: en
Type: article
Access and Citation
Cited By Count: 1
AI Researcher Chatbot
Get quick answers to your questions about the article from our AI researcher chatbot