Usage Note 20336: Calculated name cannot be a subset of an existing calculated name
With SPD Server, you cannot have a calculated name that is a subset of
an existing calculated name. The comparison does not take length
into account, and this may cause the subset to match the wrong name.
For example:
proc sql;
connect to sasspds(dbq='tmp' server=localhost.5127 user='anonymous');
execute(reset _plan _tree _method)by sasspds;
select * from connection to sasspds(
select BRAND,
EXTRACT_DATE,
sum(case when FRL_DELINQ_THIS_MONTH='GOOD' then NUMBER_ACCOUNTS
else 0
end) as GOOD,
sum(case when FRL_DELINQ_THIS_MONTH='GOOD' and
FRL_DELINQ_1MONTH_ON='CLASSIFIED' then NUMBER_ACCOUNTS
else 0
end) as GOOD_TO_CLASSIFIED,
(calculated GOOD) as DENOMINATOR,
(calculated GOOD_TO_CLASSIFIED) as NUMERATOR from Sample
group by BRAND,
EXTRACT_DATE);
quit;
In this example, GOOD is a subset of GOOD_TO_CLASSIFIED.
The comparison is incorrectly comparing the 4-character string GOOD.
Select 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 NT Workstation | 4.4 | | 9.1 TS1M3 | |
| Solaris | 4.4 | | 9.1 TS1M3 | |
| 64-bit Enabled Solaris | 4.4 | | 9.1 TS1M3 | |
| Solaris for x64 | 4.4 | | 9.1 TS1M3 | |
| Linux on Itanium | 4.4 | | 9.1 TS1M3 | |
| HP-UX | 4.4 | | 9.1 TS1M3 | |
| HP-UX IPF | 4.4 | | 9.1 TS1M3 | |
| 64-bit Enabled HP-UX | 4.4 | | 9.1 TS1M3 | |
| Tru64 UNIX | 4.4 | | 9.1 TS1M3 | |
| 64-bit Enabled AIX | 4.4 | | 9.1 TS1M3 | |
| AIX | 4.4 | | 9.1 TS1M3 | |
*
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: | Usage Note |
| Priority: | |
| Topic: | System Administration ==> Servers ==> SPDS
|
| Date Modified: | 2007-06-21 15:31:59 |
| Date Created: | 2007-06-05 14:48:32 |
