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