SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 38501: A details table analysis fails when the same variable name is used across multiple event types

DetailsHotfixAboutRate It

A details table analysis fails when the same variable name is used across multiple event types. The log for the details table contains an error message similar to the following:

ERROR: Column TECH_CLM_CMMT could not be found in the table/view identified with the correlation name a.
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
NOTE: The SAS System stopped processing this step because of errors.
The problem occurs because a query is missing the distinct keyword.

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.