STAR JOIN results for Left Outer-Join do not match the results of the MATCH FILES Procedure

Flash (Alert)


Abstract

The results of STAR JOIN matching may be inaccurate when non-sequential numerical keys with large gaps are present in the primary file.

Content

DESCRIPTION:
The STAR JOIN merge functionality may produce inaccurate results when non-sequential numerical keys with large gaps are present in the primary file. The resulting dataset may not contain all the merged data that would be expected if compared to the results of the alternate MATCH FILES procedure. The original files that are used in the STAR JOIN process are not corrupted. Please see PM85344 for additional details on test scenarios.

AFFECTED PLATFORMS:
IBM SPSS Statistics 21.0 FP1

REMEDIATION:
Until a fix for this issue is applied, customers should not use the STAR JOIN feature and should use the older Merge Files procedure as an alternative. The Merge Files procedure is described in the product Help and the Syntax Guide.

FIX:
SPSS Statistics 21.0 FP1 IF003 has been released to address this problem. Please see the SPSS Statistics 21.0 FP1 (Interim Fix 3) for more details


Note: The content of this Alert is based on the best available information as of the date of its publication.


Related information

SPSS Statistics 21.0 Fix Pack 1 Interim Fix 3 Fix List

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

SPSS Statistics

Software version:

21.0

Operating system(s):

AIX, HP-UX, Linux, Mac OS, Solaris, Windows

Reference #:

1640177

Modified date:

2013-06-07

Translate my page

Machine Translation

Content navigation