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:

1. Close all Microsoft Office applications on the client machine
2. 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.

3. 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.

 

4. 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.

    

5. 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

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
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