Problem Note 7062: WHERE Expression window may not create subset if column name contains
"PUT"
If you attempt to subset a data set using the WHERE Expression window
from the VIEWTABLE window or from a data table, data form, table viewer,
or form viewer within a SAS/AF FRAME entry and the subset criteria
includes a column with a name containing the letters "PUT", the WHERE
subset may not be created and you will see the following messages on the
message line and in the SAS Log, respectively:
ERROR: Syntax error while parsing the WHERE clause.
ERROR: Statement is not valid or it is used out of proper order.
To circumvent this problem in the VIEWTABLE window, use the WHERE
command.
A Technical Support hot fix for Release 8.2 TSLEVEL TS2M0 for this
issue is available at:
http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#007062
Operating System and Release Information
| SAS System | SAS/AF | Microsoft Windows 95/98 | 8 TS M0 | |
| Microsoft Windows NT Workstation | 8 TS M0 | |
| Microsoft Windows XP Professional | 8.2 TS2M0 | 9 TS M0 |
| Windows Millennium Edition (Me) | 8.2 TS2M0 | |
| Microsoft Windows 2000 Professional | 8 TS M0 | |
| Microsoft Windows 2000 Server | 8 TS M0 | |
| Microsoft Windows 2000 Datacenter Server | 8 TS M0 | |
| Solaris | 8 TS M0 | |
| Microsoft Windows 2000 Advanced Server | 8 TS M0 | |
| 64-bit Enabled Solaris | 8 TS M0 | |
| IRIX | 8 TS M0 | |
| Linux | 8.2 TS2M0 | 9 TS M0 |
| OS/2 | 8 TS M0 | |
| ABI+ for Intel Architecture | 8 TS M0 | |
| OpenVMS Alpha | 8 TS M0 | |
| HP-UX | 8 TS M0 | |
| 64-bit Enabled HP-UX | 8 TS M0 | |
| 64-bit Enabled AIX | 8 TS M0 | |
| AIX | 8 TS M0 | |
| Tru64 UNIX | 8 TS M0 | |
*
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: | medium |
| Date Modified: | 2002-05-01 15:20:44 |
| Date Created: | 2002-03-06 14:05:40 |
