Problem Note 57869: The COMPRESS function used with a K modifier returns incorrect results in SAS® Scalable Performance Data Server
An attempt to use the COMPRESS function with a K modifier might return incorrect results in SAS SPD Server. Incorrect results occur because SAS SPD Server does not support COMPRESS function with a third K argument.
A NOTE similar to the following is reported in the SAS log:
36 %let SPDSWDEB=YES;
37 proc sql;
38 create table abc as select distinct rovat from
spdslib.test_compress
39 where
40 valid_from_dttm <= datetime() <= valid_to_dttm
41 and compress(rovat, "0123456789", "K")="32";
whinit: WHERE ((VALID_FROM_DTTM<=1.76356e+09) and (COMPRESS(ROVAT, '0123456789',
'K')='32') and (VALID_TO_DTTM>
=1.76356e+09))
whinit: wh-tree presented
/-NAME = [VALID_FROM_DTTM]
/-CLE----|
| \-LITN = [1.76356e+09 DATETIME]
--LAND---|
| /-FUNC = [COMPRESS()]
| /-FLST---|
| | |--NAME = [ROVAT]
| | |--LITC = ['0123456789']
| | \-LITC = ['K']
|--CEQ----|
| \-LITC = ['32']
| /-NAME = [VALID_TO_DTTM]
\-CGE----|
\-LITN = [1.76356e+09 DATETIME]
whinit: wh-tree after pruning
/-NAME = [VALID_FROM_DTTM]
/-CLE----|
| \-LITN = [1.76356e+09 DATETIME]
--LAND---|
| /-NAME = [VALID_TO_DTTM]
\-CGE----|
\-LITN = [1.76356e+09 DATETIME]
whinit returns: SOME EVAL2
NOTE: Where clause requires SAS filtering support which could affect
performance. (See SPDSWDEB=YES for details.)
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SPDS | Scalable Performance Data Server | Microsoft® Windows® for x64 | 5.1 HF4 | 5.1 HF6 | | |
Microsoft Windows Server 2003 for x64 | 5.1 HF4 | 5.1 HF6 | | |
Microsoft Windows Server 2012 Datacenter | 5.1 HF4 | 5.1 HF6 | | |
Microsoft Windows Server 2012 R2 Datacenter | 5.1 HF4 | 5.1 HF6 | | |
Windows 7 Enterprise x64 | 5.1 HF4 | 5.1 HF6 | | |
64-bit Enabled AIX | 5.1 HF4 | 5.1 HF6 | | |
64-bit Enabled Solaris | 5.1 HF4 | 5.1 HF6 | | |
HP-UX IPF | 5.1 HF4 | 5.1 HF6 | | |
Linux for x64 | 5.1 HF4 | 5.1 HF6 | | |
Solaris for x64 | 5.1 HF4 | 5.1 HF6 | | |
*
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: | alert |
Date Modified: | 2016-03-30 13:57:57 |
Date Created: | 2016-03-16 09:18:40 |