Usage Note 19846: How to generate the SAS® Add-In for Microsoft Office (AMO) log with SAS Financial Management releases prior to 5.3
For SAS Financial Management release 5.3 or later, please see
SAS Note 46178.
The SAS Add-In for Microsoft Office (AMO) log records information about queries generated via the SAS Add-Ins for Microsoft Office applications, such as the SAS Financial Management Add-In for Microsoft Excel.
The SAS Add-In for Microsoft Office log is useful for diagnosing instances of
unexpected behavior when using Microsoft Office applications to retrieve data from SAS applications or SAS servers.
To activate the log:
- Close all Microsoft Office applications on the client machine
- Add the <SAS.OfficeAddin.dll.config> file to the following location on the client machine:
For SAS Financial Management release 4.x:
<<drive>:\Program Files\SAS\Add-In for Microsoft Office\>
For SAS Financial Management release 5.1:
<<drive>:\Program Files\SAS\Add-InForMicrosoftOffice\4.x\>
Please select the 'highest' release directory under the Add-InForMicrosoftOffice.
PLEASE NOTE THAT THE <SAS.OfficeAddin.dll.config> FILE IS NO LONGER REQUIRED BEGINNING WITH SAS FINANCIAL MANAGEMENT RELEASE 5.2.
- For SAS Financial Management releases prior to 5.3, also add the <SAS.Solutions.OfficeAddin.dll.config> file to the following location on the client machine:
For SAS Financial Management release 4.4:
<<drive>:\Program Files\SAS\SAS Solutions Services\Add-In for Microsoft Office\>
For SAS Financial Management release 5.x:
<<drive>:\Program Files\SAS\SASSolutionsServicesAdd-InforMicrosoftOffice\5.x\>
Please select the 'highest' release directory under the SASSolutionsServicesAdd-InforMicrosoftOffice.
Please note that the <SAS.OfficeAddin.dll.config> file is not the same as the <SAS.OfficeAddin.dll> file. In addition, the <SAS.Solutions.OfficeAddin.dll.config> is not the same as the <SAS.Solutions.OfficeAddin.dll> file.
- To control the amount of output written to the SAS Add-In for Microsoft Office log in SAS Financial Management releases prior to 5.3, open the <SAS.Solutions.OfficeAddin.dll.config> file with a standard text editor (such as Notepad, WordPad, or TextPad) and modify the 3rd line of the file
<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 log applies
to all Microsoft Office products, not selectively to Excel, Word, or PowerPoint.
Select the "Download" tab above to access the <SAS.OfficeAddin.dll.config> and the <SAS.Solutions.OfficeAddin.dll.config> files.
PLEASE NOTE THAT THE CONTENT OF THE <SAS.Solutions.OfficeAddin.dll.config> FILE HAS CHANGED
IN SAS FINANCIAL MANAGEMENT RELEASE 5.2, SO PLEASE PAY ATTENTION TO WHICH 'VERSION' OF THE <...OfficeAddin.dll.config> FILES YOU DOWNLOAD.
For instructions on how to disable the AMO log window and direct the AMO log output to a file, please refer to SAS Note 38063.
Operating System and Release Information
SAS System | SAS Financial Management | Microsoft® Windows® for x64 | 4.4 | | 9.1 TS1M3 SP4 | |
Microsoft Windows 2000 Advanced Server | 4.0 | | 9.1 TS1M3 | |
Microsoft Windows 2000 Datacenter Server | 4.0 | | 9.1 TS1M3 | |
Microsoft Windows 2000 Server | 4.0 | | 9.1 TS1M3 | |
Microsoft Windows 2000 Professional | 4.0 | | 9.1 TS1M3 | |
Microsoft Windows Server 2003 Datacenter Edition | 4.0 | | 9.1 TS1M3 | |
Microsoft Windows Server 2003 Enterprise Edition | 4.0 | | 9.1 TS1M3 | |
Microsoft Windows Server 2003 Standard Edition | 4.0 | | 9.1 TS1M3 | |
Microsoft Windows XP Professional | 4.0 | | 9.1 TS1M3 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
To access the
<SAS.OfficeAddin.dll.config> file for SAS Financial Management releases
prior to 5.2,
click here
To access the
<SAS.Solutions.OfficeAddin.dll.config> file for SAS Financial Management releases
4.4 and 5.1 only,
click here
To access the
<SAS.Solutions.OfficeAddin.dll.config> file for SAS Financial Management release
5.2,
click here
Contains information about how to enable the SAS Add-in for Microsoft Office log.
Type: | Usage Note |
Priority: | medium |
Date Modified: | 2012-03-30 10:50:09 |
Date Created: | 2007-03-26 17:04:59 |