Problem Note 43849: An Application Error might occur when using "Filter the summarized data" in the Query Builder task in SAS® Enterprise® Guide
In the Query Builder, if you attempt to create an advanced filter for a column listed under Filter the summarized data on the Filter Data tab, an Application Error similar to the following will occur.
SAS Enterprise Guide has encountered a problem. We recommend that you save your
work and restart SAS Enterprise Guide.
---------------------------------------------------------------------------------
System.NullReferenceException
Object reference not set to an instance of an object.
-------------------------- Technical Information Follows ------------------------
System.NullReferenceException: Object reference not set to an instance of an
object.
at SAS.Shared.UtilityFunctions.SASValidLiteral(String Text, Boolean
NoTrailingN, Boolean UseDoubleQuotes)
at SAS.Shared.UtilityFunctions.SASValidLiteral(String Text)
at SAS.EG.QueryModel.EGQueryModel.GetGroupByString(Boolean bUseValidSASName)
at SAS.EG.QueryModel.EGQueryModel.GetGroupByClause(Boolean bUseValidSASName)
at SAS.EG.QueryModel.EGQueryModel.GetGroupByClause()
at SAS.EG.QueryModel.EGQueryModel.GetSelectStatement(Boolean bIncludeUsing,
Boolean bUseValidSASName, Boolean bExplicitPassthrough)
at SAS.EG.QueryModel.EGQueryModel.GetValidateSubmitString()
at SAS.EG.ProjectElements.Query.GetValidateSubmitString()
at SAS.EG.ProjectElements.Forms.QueryBuilder.ValidateQuery(Boolean sync)
at SAS.EG.ProjectElements.Forms.QueryBuilder.UpdateCode()
at SAS.EG.ProjectElements.Forms.QueryBuilder.AddFilter(FilterTree tree,
FilterNode parent)
at SAS.EG.ProjectElements.Forms.QueryBuilder.OnNewFilterRequested(Object
sender, FilterListEventArgs e)
at SAS.EG.ProjectElements.Forms.QueryBuilder.FilterList_FilterEvent(Object
sender, FilterListEventArgs e)
at SAS.SharedUI.QueryFilters.FilterList.cmdNewFilter_Click(Object sender,
EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at SAS.SharedUI.Controls.SASImagePushButton.OnMouseUp(MouseEventArgs e)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button,
Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at SAS.SharedUI.Controls.SASImagePushButton.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr
wparam, IntPtr lparam)
--------------------------- End of Technical Information ------------------------
To circumvent the problem, use the first query to create the summary column, then create a second query to do the Advanced Filter for Filter the raw data on the new summary column created in the first query.
Operating System and Release Information
| SAS System | SAS Enterprise Guide | Microsoft® Windows® for x64 | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Standard Edition | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 for x64 | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2008 | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2008 for x64 | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows XP Professional | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Windows 7 Enterprise 32 bit | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Windows 7 Enterprise x64 | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Windows 7 Home Premium 32 bit | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Windows 7 Home Premium x64 | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Windows 7 Professional 32 bit | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Windows 7 Professional x64 | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Windows 7 Ultimate 32 bit | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Windows 7 Ultimate x64 | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Windows Vista | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Windows Vista for x64 | 4.305 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2011-08-19 15:04:21 |
| Date Created: | 2011-07-28 10:01:45 |
