Usage Note 40069: Question mark entered as a constant in the Viewtable WHERE EXPRESSION window might yield unexpected results
 |  |  |  |
When attempting to use the WHERE EXPRESSION window within the Viewtable interface, you could experience unexpected results.
If you attempt to define a WHERE subset for your table, and enter a ? as a constant value, you might see the following Help window display:
However, if you select <LOOKUP distinct values> instead of <CONSTANT enter value>, you can select the ? from the list of values for the column and the Help window will not display.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/AF | Microsoft Windows 2000 Advanced Server | 9.1 TS1M0 | |
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.1 TS1M0 | |||
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M0 | |||
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M0 | |||
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.1 TS1M0 | |||
| z/OS | 9.1 TS1M0 | |||
| Microsoft Windows 2000 Server | 9.1 TS1M0 | |||
| Microsoft Windows 2000 Professional | 9.1 TS1M0 | |||
| Microsoft Windows NT Workstation | 9.1 TS1M0 | |||
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M0 | |||
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M0 | |||
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M0 | |||
| Microsoft Windows XP Professional | 9.1 TS1M0 | |||
| 64-bit Enabled AIX | 9.1 TS1M0 | |||
| 64-bit Enabled HP-UX | 9.1 TS1M0 | |||
| 64-bit Enabled Solaris | 9.1 TS1M0 | |||
| HP-UX IPF | 9.1 TS1M0 | |||
| Linux | 9.1 TS1M0 | |||
| OpenVMS Alpha | 9.1 TS1M0 | |||
| Tru64 UNIX | 9.1 TS1M0 | |||
| Type: | Usage Note |
| Priority: | medium |
| Topic: | Common Programming Tasks |
| Date Modified: | 2010-06-28 15:11:52 |
| Date Created: | 2010-06-21 16:42:12 |