SUPPORT / SAMPLES & SAS NOTES
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
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| 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 | ||||