PM72589: STAR JOIN SYNTAX PRODUCE WRONG MERGE RESULT

APAR status

• Closed as program error.

Error description

• You work with IBM SPSS Statistics 21 and used the new STAR JOIN
  syntax e.g with a structure like the one below for two files
  with one key variable:
  
  STAR JOIN
    /SELECT t0.keyvar, t1.v1, t1.v2
    /FROM * AS t0
    /JOIN 'DataSet4' AS t1
      ON t0.keyvar=t1.keyvar
    /OUTFILE FILE=*.
  
  However, on the merged file the results do not look correct, too
  few cases were merged.
  
  Similar wrong results have been encountered when the key
  variables contain string fields of differing lengths.
  
  This was reported to IBM SPSS Development. As a workaround
  please use MATCH FILES syntax instead.
  Please save both files in ascending order of the key variables
  first and save both files in that order. Both files can than be
  matched (both files provide cases option).
  
  
  MATCH FILES
    /FILE= 'C:\temp\file1.sav'
    /FILE='C:\temp\file2.sav'
    /BY keyvar.
  EXECUTE.
  

Local fix

• Most aspects of this issue have been addressed in Statistics 21
  Fix Pack 1. Please upgrade to this version.  If you are still
  seeing this issue after upgrading, please refer to APAR PM85344.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users working with STAR JOIN command                         *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * You work with IBM SPSS Statistics 21 and used the new STAR   *
  * JOIN                                                         *
  * syntax e.g with a structure like the one below for two files *
  * with one key variable:                                       *
  *                                                              *
  * STAR JOIN                                                    *
  *   /SELECT t0.keyvar, t1.v1, t1.v2                            *
  *   /FROM * AS t0                                              *
  *   /JOIN 'DataSet4' AS t1                                     *
  *     ON t0.keyvar=t1.keyvar                                   *
  *   /OUTFILE FILE=*.                                           *
  *                                                              *
  * However, on the merged file the results do not look correct, *
  * too                                                          *
  * few cases were merged.                                       *
  *                                                              *
  * Similar wrong results have been encountered when the key     *
  * variables contain string fields of differing lengths.        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * This issue has been addressed in Statistics 21 Fix Pack 1.   *
  * Please upgrade to this version.                              *
  ****************************************************************
  

Problem conclusion

• This issue has been addressed in Statistics 21 Fix Pack 1.
  Please upgrade to this version.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  SPSS STATISTICS

• Fixed component ID

  5725A54ST

Applicable component levels

• RL00 PSN

     UP

• RL00 PSY

     UP