Problem Note 46192: A summary column in the Query Builder filter might cause errors after migrating to SAS® Enterprise Guide® 5.1
 |  |  |  |  |
A summary column in a Query Builder task might cause subsequent tasks to fail with an error similar to the following:
ERROR: The task refers to variables that are not in the input data source. Please review the variable assignments.
This problem occurs because the Query Builder task renames summary columns after migrating a project to SAS Enterprise Guide 5.1.
To circumvent the problem, modify the query and rename the summary column to the original column name.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Enterprise Guide | Windows Vista for x64 | 5.1 | 6.1 | 9.3 TS1M0 | 9.3 TS1M0 |
| Windows Vista | 5.1 | 6.1 | 9.3 TS1M0 | 9.3 TS1M0 | ||
| Windows 7 Ultimate 32 bit | 5.1 | 6.1 | 9.3 TS1M0 | 9.3 TS1M0 | ||
| Windows 7 Professional 32 bit | 5.1 | 6.1 | 9.3 TS1M0 | 9.3 TS1M0 | ||
| Windows 7 Home Premium x64 | 5.1 | 6.1 | 9.3 TS1M0 | 9.3 TS1M0 | ||
| Windows 7 Home Premium 32 bit | 5.1 | 6.1 | 9.3 TS1M0 | 9.3 TS1M0 | ||
| Windows 7 Enterprise x64 | 5.1 | 6.1 | 9.3 TS1M0 | 9.3 TS1M0 | ||
| Windows 7 Enterprise 32 bit | 5.1 | 6.1 | 9.3 TS1M0 | 9.3 TS1M0 | ||
| Microsoft Windows XP Professional | 5.1 | 6.1 | 9.3 TS1M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2008 for x64 | 5.1 | 6.1 | 9.3 TS1M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2008 | 5.1 | 6.1 | 9.3 TS1M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 for x64 | 5.1 | 6.1 | 9.3 TS1M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 5.1 | 6.1 | 9.3 TS1M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 5.1 | 6.1 | 9.3 TS1M0 | 9.3 TS1M0 | ||
| Microsoft® Windows® for x64 | 5.1 | 6.1 | 9.3 TS1M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 5.1 | 6.1 | 9.3 TS1M0 | 9.3 TS1M0 | ||
| Windows 7 Professional x64 | 5.1 | 6.1 | 9.3 TS1M0 | 9.3 TS1M0 | ||
| Windows 7 Ultimate x64 | 5.1 | 6.1 | 9.3 TS1M0 | 9.3 TS1M0 | ||
A fix for this issue for SAS Enterprise Guide 5.1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/G35.html#46192A fix for this issue for SAS Add-in for Microsoft Office 5.1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/G36.html#46192| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2012-04-04 15:26:47 |
| Date Created: | 2012-04-02 10:45:13 |