Problem Note 17971: Query may not filter correctly for datetime values in SAS® Enterprise
Guide®
The Query Builder may not filter datetime values correctly in SAS
Enterprise Guide. For example, if the formatted value for a datetime
value is '01JAN2006:10:11:12.123456', and that value is selected from
the list of data values for a filter, the query result will not find the
match. The reason is the value used in the filter is
'01JAN2006:10:11:12'dt, instead of '01JAN2006:10:11:12.123456'dt.
To circumvent the problem, unselect 'Use formatted dates' in the Edit
Filter window of the Query Builder.
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| SAS System | SAS Enterprise Guide | Microsoft Windows XP Professional | 4.1 | 4.2 | 9.1 TS1M3 SP1 | 9.2 TS2M0 |
*
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: | high |
| Date Modified: | 2006-10-11 07:24:54 |
| Date Created: | 2006-06-29 17:30:58 |
