SUPPORT / SAMPLES & SAS NOTES
Problem Note 60336: Certain Microsoft Excel filenames cause an error in SAS® Enterprise Guide® when using Get Values in the Query Builder
 |  |  |  |  |
Certain Microsoft Excel filenames cause an error when you use Get Values in the Filter section of the Query Builder. This problem is most likely to occur when the Excel filename includes multiple embedded spaces and parentheses. For example, an Excel file named TestFile with space (t).xlsx causes the following error:
There was an error getting distinct values.
Distinct values will not be available.
Distinct values will not be available.
To circumvent this problem, you must rename the Excel file.
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 | Microsoft® Windows® for x64 | 7.11 | 7.12 | 9.3 TS1M0 | 9.4 TS1M3 |
| Microsoft Windows Server 2008 | 7.11 | 7.12 | 9.3 TS1M0 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2008 R2 | 7.11 | 7.12 | 9.3 TS1M0 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2008 for x64 | 7.11 | 7.12 | 9.3 TS1M0 | 9.4 TS1M3 | ||
| Windows 7 Enterprise 32 bit | 7.11 | 7.12 | 9.3 TS1M0 | 9.4 TS1M3 | ||
| Windows 7 Enterprise x64 | 7.11 | 7.12 | 9.3 TS1M0 | 9.4 TS1M3 | ||
| Windows 7 Home Premium 32 bit | 7.11 | 7.12 | 9.3 TS1M0 | 9.4 TS1M3 | ||
| Windows 7 Home Premium x64 | 7.11 | 7.12 | 9.3 TS1M0 | 9.4 TS1M3 | ||
| Windows 7 Professional 32 bit | 7.11 | 7.12 | 9.3 TS1M0 | 9.4 TS1M3 | ||
| Windows 7 Professional x64 | 7.11 | 7.12 | 9.3 TS1M0 | 9.4 TS1M3 | ||
| Windows 7 Ultimate 32 bit | 7.11 | 7.12 | 9.3 TS1M0 | 9.4 TS1M3 | ||
| Windows 7 Ultimate x64 | 7.11 | 7.12 | 9.3 TS1M0 | 9.4 TS1M3 | ||
| 64-bit Enabled AIX | 7.11 | 7.12 | 9.3 TS1M0 | 9.4 TS1M3 | ||
| 64-bit Enabled Solaris | 7.11 | 7.12 | 9.3 TS1M0 | 9.4 TS1M3 | ||
| HP-UX IPF | 7.11 | 7.12 | 9.3 TS1M0 | 9.4 TS1M3 | ||
| Linux | 7.11 | 7.12 | 9.3 TS1M0 | 9.4 TS1M3 | ||
| Linux for x64 | 7.11 | 7.12 | 9.3 TS1M0 | 9.4 TS1M3 | ||
| Solaris for x64 | 7.11 | 7.12 | 9.3 TS1M0 | 9.4 TS1M3 | ||