Logging for SAS Add-In for Microsoft Office is not turned on by default.

To turn on logging, follow these steps. These steps apply to releases 2.1, 4.2, and 4.3.

1. Close all Microsoft Office applications on the client machine.
2. Create a file named SAS.OfficeAddin.dll.config and place it in the following location on the client machine:

For version 2.1, place the file here:

drive:\Program Files\SAS\Add-In for Microsoft Office\

For version 4.2 or 4.3, place the file here:

drive:\Program Files\SAS\Add-InForMicrosoftOffice\4.x

Note: This assumes that SAS Add-In for Microsoft Office was installed in the default location. If you did not install it in the default location, place the config file in the directory where you installed SAS Add-In for Microsoft Office.

3. Edit SAS.OfficeAddin.dll.config to add the following lines:

<configuration>
    <assemblySettings> 
        <add key="ShowMessageLog" value="true"/>
    </assemblySettings> 
</configuration> 

4. Save the file.
5. Launch one of the Microsoft Office applications. A SAS Add-In Message Log dialog box should open automatically.



6. Perform a SAS reporting task to see how information about the query appears in the log.

For information about how to enable logging in SAS Add-In 5.1 for Microsoft Office, see SAS Note 45866..

Operating System and Release Information