SUPPORT / SAMPLES & SAS NOTES
Problem Note 41532: Sorting by certain computed column names in the Query Builder of SAS® Enterprise Guide® might generate errors
 |  |  |  |  |
If the name of a computed column contains embedded spaces, then sorting by that column in the Query Builder will cause an error similar to the following:
ERROR: The following columns were not found in the contributing tables: Column_Name.
The error occurs because the ORDER clause of the PROC SQL incorrectly changes the embedded spaces to underscores.
The only circumvention is to remove embedded spaces from the computed column name and alias.
Select 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 | 4.3 | 4.305 | 9.2 TS2M3 | 9.2 TS2M3 |
| Windows 7 Ultimate x64 | 4.3 | 4.305 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Windows Vista | 4.3 | 4.305 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Windows 7 Ultimate 32 bit | 4.3 | 4.305 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Windows 7 Professional x64 | 4.3 | 4.305 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Windows 7 Professional 32 bit | 4.3 | 4.305 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Windows 7 Home Premium 32 bit | 4.3 | 4.305 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Windows 7 Home Premium x64 | 4.3 | 4.305 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Windows 7 Enterprise x64 | 4.3 | 4.305 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Windows 7 Enterprise 32 bit | 4.3 | 4.305 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Microsoft Windows XP Professional | 4.3 | 4.305 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2008 for x64 | 4.3 | 4.305 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2008 | 4.3 | 4.305 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.3 | 4.305 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 for x64 | 4.3 | 4.305 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.3 | 4.305 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 4.3 | 4.305 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Microsoft® Windows® for x64 | 4.3 | 4.305 | 9.2 TS2M3 | 9.2 TS2M3 | ||