Database Reference
In-Depth Information
The final result is an Excel workbook with a label that reads “Greetings World” in cell A1 and the word
“Hello” in cell A2, as shown in Figure 12.3.2a. The background view in this Excel file is slightly different
than usual because the ODS option “Style=minimal” was used when creating the *.xml file. Other style
options are available and produce different results. The font size of the headers and the text in the cells is
also different in each cell.
Figure 12.3.2a: Excel Output of the Code from Figure 12.3.1.
12.3.2 Prepare Excel to Open the File Output by SAS
The SAS code was the easy part; now on to the Excel setup. Most Excel users know that Excel will record
a macro, and the macro can be associated with a key-stroke command that will run the macro. These
macros are usually stored within the current workbook, or deleted before exiting Excel. What most users do
not know is that Excel has a way to store macros so that they are available to be used on all workbooks on a
given computer, and not stored with the workbook. Furthermore, there is a way to give those macros
control of Excel before the spreadsheets are visible to the user. An Excel Personal Macro Workbook is
stored in a location that Excel loads before accessing the spreadsheets. See Figure 12.3.2b. These
commands (macros) are available before other workbooks are loaded into Excel. The Windows default file
names and locations are listed in Table 12.3.2.
 
Search WWH ::




Custom Search