SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 38477: A details table on a subset data selection of a text analysis fails

DetailsHotfixAboutRate It

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 FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Warranty AnalysisMicrosoft Windows Server 2003 Datacenter Edition4.14.29.1 TS1M3 SP49.2 TS2M2
Microsoft Windows Server 2003 Enterprise Edition4.14.29.1 TS1M3 SP49.2 TS2M2
Microsoft Windows Server 2003 Standard Edition4.14.29.1 TS1M3 SP49.2 TS2M2
64-bit Enabled AIX4.14.29.1 TS1M3 SP49.2 TS2M2
64-bit Enabled Solaris4.14.29.1 TS1M3 SP49.2 TS2M2
HP-UX IPF4.14.29.1 TS1M3 SP49.2 TS2M2
* 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.