SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 10649: Too many records are output when running an export

DetailsHotfixAboutRate It
If you run an export in the SAS Campaign Management component where a
subsidiary table in the interface definition contains a compound key,
more records may be output than expected.

This occurs because the generated SQL cannot always determine a minimum
or maximum value for the compound key field.  Consequently, for
selection group members who have multiple matches in the subsidiary
table, the ordering algorithm is unable to limit the export rows to a
single value, so it writes all matching records.  As a result, too many
records are output to the export file.


A Technical Support hot fix for this issue is available at:
http://ftp.sas.com/techsup/download/hotfix/cam75.html


Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Campaign ManagementMicrosoft Windows NT Workstation7.4
Microsoft Windows XP Professional7.4
Microsoft Windows 2000 Professional7.4
Microsoft Windows 2000 Advanced Server7.4
Microsoft Windows 2000 Server7.4
Microsoft Windows 2000 Datacenter Server7.4
* 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.