Using an analysis variable with all missing values prevents the summary statistics task from running in SAS® Enterprise Guide® and the SAS® Add-In for Microsoft Office.
In SAS Enterprise Guide, you see the following error:
SAS Enterprise Guide has encountered a problem and needs to close. We are sorry for the inconvenience. ------------------------------------------------------------------------------- System.OverflowException Value was either too large or too small for a Decimal. -------------------- Technical Information Follows---------------------------- System.OverflowException: Value was either too large or too small for a Decimal. at System.Decimal..ctor(Double value) at SAS.EG.Tasks.SummaryStatistics.SummaryStatisticsModel.CalculateDefaultMidpoints( Role rVar) at SAS.EG.Tasks.SummaryStatistics.SummaryStatisticsModel.VarRoleChanged(Object sender, StateChangedEventArgs e) at SAS.EG.Tasks.TaskSDK.StateChangedEventHandler.Invoke(Object sender, StateChangedEventArgs e) at SAS.EG.Tasks.TaskSDK.TaskStateObject.OnStateChanged(StateChangedEventArgs rea) at SAS.EG.Tasks.TaskSDK.TaskStateObject.RaiseStateChanged(StateChangedEventArgs ea) at SAS.EG.Tasks.TaskSDK.ColumnsPanel.variableSelector_VariableAssigned(Object sender, VariableAssignedEventArgs ea) at SAS.EG.Controls.SASVariableSelector.AssignVar(SASVariable varItem, SASRole roleItem, Int32 insertAt) at SAS.EG.Controls.SASVariableSelector.treeRoles_DragDrop(Object sender, DragEventArgs e) --------------------- End of Technical Information----------------------------
In the SAS Add-In, you see the following error:
System.NullReferenceException: Object reference not set to an instance of an object. at SAS.OfficeAddin.SasDataSource.GenerateStatistics() at SAS.OfficeAddin.SASDataAccessor.GenerateStatistic() at SAS.EG.Tasks.TaskSDK.Dataset.GenerateStatistics() at SAS.EG.Tasks.SummaryStatistics.SummaryStatisticsModel.ActiveDataHasChanged(Filte rSettings filterSettings) at SAS.EG.Tasks.TaskSDK.TaskModel.ActiveDataChanged() at SAS.Shared.AddIns.Management.AddInProxy.ActiveDataChanged() at SAS.OfficeAddin.Task.PrepareEGTask(EGTaskInfo taskInfo, Boolean showDialog, Boolean delayProxyCleanup) at SAS.OfficeAddin.Task.PrepareTask(Boolean showDialog, Boolean delayProxyCleanup) at SAS.OfficeAddin.Task.BeforeExecute(BeforeExecuteEventArgs e) at SAS.OfficeAddin.OfficeAddinBase.LaunchRunnable(IRunnable job, Boolean showDialog, JobResultLocation location) at SAS.OfficeAddin.OfficeAddinBase.LaunchFromRunnableInfo(IRunnableInfo jobInfo) at SAS.OfficeAddin.OfficeAddinBase.OnTaskInvoked(Object sender, TaskInvokedEventArgs e) at SAS.OfficeAddin.UIManager.OnTaskInvoked(String classId) at SAS.OfficeAddin.RibbonManager.OnButtonClick(IRibbonControl control)
Select the Hot Fix tab in this note to access the hot fix for this issue.
Product Family | Product | System | Product Release | SAS Release | ||
Reported | Fixed* | Reported | Fixed* | |||
SAS System | SAS Add-in for Microsoft Office | Microsoft® Windows® for x64 | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M1 |
Microsoft Windows Server 2003 Datacenter Edition | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M1 | ||
Microsoft Windows Server 2003 Enterprise Edition | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M1 | ||
Microsoft Windows Server 2003 Standard Edition | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M1 | ||
Microsoft Windows Server 2003 for x64 | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M1 | ||
Microsoft Windows Server 2008 | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M1 | ||
Microsoft Windows Server 2008 for x64 | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M1 | ||
Microsoft Windows XP Professional | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M1 | ||
Windows 7 Enterprise 32 bit | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M1 | ||
Windows 7 Enterprise x64 | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M1 | ||
Windows 7 Home Premium 32 bit | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M1 | ||
Windows 7 Home Premium x64 | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M1 | ||
Windows 7 Professional 32 bit | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M1 | ||
Windows 7 Professional x64 | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M1 | ||
Windows 7 Ultimate 32 bit | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M1 | ||
Windows 7 Ultimate x64 | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M1 | ||
Windows Vista | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M1 | ||
Windows Vista for x64 | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M1 | ||
SAS System | SAS Enterprise Guide | Microsoft® Windows® for x64 | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M1 |
Microsoft Windows Server 2003 Datacenter Edition | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M1 | ||
Microsoft Windows Server 2003 Enterprise Edition | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M1 | ||
Microsoft Windows Server 2003 Standard Edition | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M1 | ||
Microsoft Windows Server 2003 for x64 | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M1 | ||
Microsoft Windows Server 2008 | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M1 | ||
Microsoft Windows Server 2008 for x64 | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M1 | ||
Microsoft Windows XP Professional | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M1 | ||
Windows 7 Enterprise 32 bit | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M1 | ||
Windows 7 Enterprise x64 | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M1 | ||
Windows 7 Home Premium 32 bit | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M1 | ||
Windows 7 Home Premium x64 | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M1 | ||
Windows 7 Professional 32 bit | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M1 | ||
Windows 7 Professional x64 | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M1 | ||
Windows 7 Ultimate 32 bit | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M1 | ||
Windows 7 Ultimate x64 | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M1 | ||
Windows Vista | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M1 | ||
Windows Vista for x64 | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M1 |
A fix for this issue for SAS Enterprise Guide 4.305 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/C44.html#45695A fix for this issue for SAS Add-in for Microsoft Office 4.305 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/C46.html#45695A fix for this issue for SAS Enterprise Guide 4.305 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/E66.html#45695A fix for this issue for SAS Add-in for Microsoft Office 4.305 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/E67.html#45695Type: | Problem Note |
Priority: | medium |
Date Modified: | 2012-02-20 08:41:38 |
Date Created: | 2012-02-16 11:34:37 |