Logging for SAS Add-In for Microsoft Office is not turned on by default. To enable logging for the SAS Add-In 5.1 and 6.1, complete the following steps:

1. Browse to the installation location. The default path for 32-bit releases of the SAS Add-In is this:

<drive>:\Program Files\SASHome\x86\SASAddinforMicrosoftOffice\X.X, where X.X is the release of the Add-In that is installed.

If the 64-bit release of the SAS Add-In is installed, then the path is this:

<drive>:\Program Files\SASHome\SASAddinforMicrosoftOffice\X.X, where X.X is the release of the Add-In that is installed.

2. Copy the logging.config file and place it in the following location:

%appdata%\SAS\Add-InForMicrosoftOffice\X.X

When this file is present, a Logs folder is created in this location. The Logs folder will contain the logging output in a file.

As an additional step, you can also turn on the Message Log Window by following these steps.

1. Open the logging.config file in a plain text editor.
2. Look for the <root> tag, which will look similar to this:
<root> <level value="DEBUG" /> <appender-ref ref="Appender" /> <!-- To turn on the Message Log, remove this comment, so that the following line is processed. <appender-ref ref="MessageLogAppender" /> --> </root>
3. Remove the comment and comment tags from around the <appender-ref> tag. Only the <appender-ref> tag should remain. After the comment is removed, the content will look similar to this:
<root> <level value="DEBUG" /> <appender-ref ref="Appender" /> <appender-ref ref="MessageLogAppender" /> </root>

To turn off all logging, remove the logging.config file from the %appdata% folder.

For information about how to enable logging in SAS Add-In 2.1, 4.2, and 4.3, see SAS Note 31217.

Operating System and Release Information