Problem Note 38477: A details table on a subset data selection of a text analysis fails
 |  |  |  |  |
A details table on a subset data selection of a text analysis fails. The Messages tab for the details table contains "Event data set was not created." The log for the details table contains an error message about different data types:
SWAREPORT: Step 3 - Create claim filter subset (drill-to child report) ERROR: Expression using IN has components that are of different data types. NOTE: The IN referred to may have been transformed from an OR to an IN at some point during PROC SQL where clause optimization. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
This problem occurs when the primary key for the CLAIMS table of the data mart is a character variable.
No workaround is possible.
Click 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* | |||
| SAS System | SAS Warranty Analysis | Microsoft Windows Server 2003 Datacenter Edition | 4.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M2 |
| Microsoft Windows Server 2003 Enterprise Edition | 4.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M2 | ||
| 64-bit Enabled AIX | 4.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M2 | ||
| 64-bit Enabled Solaris | 4.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M2 | ||
| HP-UX IPF | 4.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M2 | ||
A fix for this issue for SAS Warranty Analysis 4.1 is available at:
http://www.sas.com/techsup/download/hotfix/warnty41.html#038477
A details table on a subset data selection of a text analysis fails. The Messages tab for the details table contains "Event data set was not created." The log for the details table contains an error message about different data types.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2010-04-05 11:10:40 |
| Date Created: | 2010-01-24 16:21:00 |