SUPPORT / SAMPLES & SAS NOTES
Problem Note 21138: An unexpected exception error occurs when using an Analyze Data task in the SAS® Add-In for Microsoft Office
 |  |  |  |  |
You might get the following error when using an Analyze Data task in the SAS Add-In for Microsoft Office.
Unexepected exception occurred in SAS Add-In for Microsoft Office.
Please report this error to your site administrator.
If you click the Details button in the error message window, the following additional errors are displayed:
System.NullReferenceException: Object reference not set to an
instance of an object.
The behavior might occur after using an Analyze Data task in which the task variables are modified. The task runs successfully on the first pass. If you then include additional variables or exclude current task variables, run the same task again, then select SAS Data Options and Variables, the error occurs.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Add-in for Microsoft Office | Microsoft Windows 2000 Professional | 2.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Microsoft Windows XP Professional | 2.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| SAS System | SAS Add-in for Microsoft Office | Microsoft Windows NT Workstation | 2.1 | 9.1 TS1M3 SP4 | ||