Select Your Region
Americas
Europe
Middle East & Africa
Asia Pacific
Usage Note 46178: Generating the SAS® Add-In for Microsoft Office log with SAS® Financial Management release 5.3 and later
 |  |  |  |  |
For SAS Financial Management releases prior to 5.3, please see SAS Note 19846.
The SAS Add-In for Microsoft Office Message log records information about queries generated via the SAS Financial Management Add-In for Microsoft Excel.
The SAS Add-In for Microsoft Office message log is useful for diagnosing instances of unexpected behavior when using Microsoft Excel applications to retrieve data from SAS applications or SAS servers.
To activate the log:
- Close all Microsoft Office applications on the client machine
- Select the "Download" tab above and extract the <SAS.FM.Common.dll.config>
from the zip file to the following location on the
client machine:
For SAS Financial Management release 5.3:
<<drive>:\Program Files\SASHome\x86\SASFinancialManagementAdd-In for Microsoft Excel\5.3> - To control the amount of output written to the SAS Add-In for Microsoft Office log, open the <SAS.FM.Common.dll.config> file with a standard text editor such as Notepad, WordPad or TextPad and modify the line
<add key="DebugLevel" value="X"/>
so that the value "X" is set to the desired logging level, as follows:
0 ERROR - only ERROR messages will be displayed in the SAS Add-In for Microsoft Office log
1 WARN - WARNING and ERROR messages will be written to the log
2 INFO - INFORMATION, WARNING, and ERROR messages will be written to the log
3 DEBUG - all messages will be written to the log
By default, the logging level is set to INFO ("DebugLevel" value="2") when you initially download this file.
Following this installation, a log window appears when Microsoft Office applications are started. The SAS Add-In for Microsoft Office message log applies to all Microsoft Office products, not selectively to Excel, Word, or PowerPoint.
To disable the SAS Add-In for Microsoft Office message log window and direct the SAS Add-In for Microsoft Office message log output to a file:
Make the following changes to your <SAS.FM.Common.dll.config> file:- Set the value of the statement
<add key="ShowMessageLog" value=...>
to "false"/.
- Set the value of the statement
<add key="LogToExternalFile" value=...>
to "true"/.
Your output is directed to a directory similar to:
on the client machine. Note that the <messages_> or the <MessageLogFile_> filename is incremented (the 'value' of 'xx' increases) each time new log information is written out to a file.<<drive:>\Users\<userid>\AppData\Local\Temp\1\MessageLogFile_xx.txt>
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Financial Management | Windows 7 Home Premium 32 bit | 5.3 | 9.3 TS1M2 | ||
| Windows 7 Enterprise x64 | 5.3 | 9.3 TS1M2 | ||||
| Windows 7 Enterprise 32 bit | 5.3 | 9.3 TS1M2 | ||||
| Microsoft Windows XP Professional | 5.3 | 9.3 TS1M2 | ||||
| Microsoft Windows Server 2008 for x64 | 5.3 | 9.3 TS1M2 | ||||
| Microsoft Windows Server 2008 | 5.3 | 9.3 TS1M2 | ||||
| Microsoft Windows Server 2003 for x64 | 5.3 | 9.3 TS1M2 | ||||
| Microsoft Windows Server 2003 Standard Edition | 5.3 | 9.3 TS1M2 | ||||
| Microsoft Windows Server 2003 Enterprise Edition | 5.3 | 9.3 TS1M2 | ||||
| Microsoft Windows Server 2003 Datacenter Edition | 5.3 | 9.3 TS1M2 | ||||
| Microsoft® Windows® for x64 | 5.3 | 9.3 TS1M2 | ||||
| Windows 7 Home Premium x64 | 5.3 | 9.3 TS1M2 | ||||
| Windows 7 Professional 32 bit | 5.3 | 9.3 TS1M2 | ||||
| Windows 7 Professional x64 | 5.3 | 9.3 TS1M2 | ||||
| Windows 7 Ultimate 32 bit | 5.3 | 9.3 TS1M2 | ||||
| Windows 7 Ultimate x64 | 5.3 | 9.3 TS1M2 | ||||
| Windows Vista | 5.3 | 9.3 TS1M2 | ||||
| Windows Vista for x64 | 5.3 | 9.3 TS1M2 | ||||
| 64-bit Enabled AIX | 5.3 | 9.3 TS1M2 | ||||
| 64-bit Enabled Solaris | 5.3 | 9.3 TS1M2 | ||||
| Linux for x64 | 5.3 | 9.3 TS1M2 | ||||