PM72589: STAR JOIN SYNTAX PRODUCE WRONG MERGE RESULT

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

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 number

    PM72589

  • Reported component name

    SPSS STATISTICS

  • Reported component ID

    5725A54ST

  • Reported release

    L00

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-09-11

  • Closed date

    2013-04-04

  • Last modified date

    2013-04-04

  • 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



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

SPSS Statistics
Statistics Desktop

Software version:

21.0

Reference #:

PM72589

Modified date:

2013-04-04

Translate my page

Machine Translation

Content navigation