IBM Support

PM55839: ADD VARIABLES PROCEDURE RENAMES DROPPED VARIABLES TO EXISTING VARIABLE NAMES, DROPPING THEM IN THE PROCESS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • You work with IBM SPSS Statistics 20 and have some large data
    files you would like to merge by using the procedure Data -
    Merge Files - Add Variables. Both files contain some variables
    named D1 to D16. After you merged the files by a key variable in
    the menu you noticed that those variables D1 to D16 have been
    dropped.
    When you paste the syntax you see that the existing variable
    named are renamed with D0 to Dxx and the existing variable names
    are replaced with their name.
    As a workaround either rename variables D1 to D16 before the
    merge or modify your syntax and remove the /Rename and /Drop
    subcommands as in the example below:
    MATCH FILES
      /FILE = 'C:\temp\File1.sav
      /TABLE = 'C:\temp\File2.sav'
      /BY id.
    execute.
    Please note that the issue only happens when you use the capital
    letter "D" for your variable names. If you use d1, d2 etc.
    instead you will not notice the behavior.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users merging data files                                     *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * You work with IBM SPSS Statistics 20 and have some large     *
    * data                                                         *
    * files you would like to merge by using the procedure Data -  *
    * Merge Files - Add Variables. Both files contain some         *
    * variables                                                    *
    * named D1 to D16. After you merged the files by a key         *
    * variable in                                                  *
    * the menu you noticed that those variables D1 to D16 have     *
    * been                                                         *
    * dropped.                                                     *
    * When you paste the syntax you see that the existing variable *
    * named are renamed with D0 to Dxx and the existing variable   *
    * names                                                        *
    * are replaced with their name.                                *
    * As a workaround either rename variables D1 to D16 before the *
    * merge or modify your syntax and remove the /Rename and /Drop *
    * subcommands as in the example below:                         *
    * MATCH FILES                                                  *
    *   /FILE = 'C:\temp\File1.sav                                 *
    *   /TABLE = 'C:\temp\File2.sav'                               *
    *   /BY id.                                                    *
    * execute.                                                     *
    * Please note that the issue only happens when you use the     *
    * capital                                                      *
    * letter "D" for your variable names. If you use d1, d2 etc.   *
    * instead you will not notice the behavior.                    *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * This issue is resolved with IBM SPSS Statistics 21 release   *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PM55839

  • Reported component name

    SPSS STATISTICS

  • Reported component ID

    5725A54ST

  • Reported release

    K00

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-01-12

  • Closed date

    2012-08-29

  • Last modified date

    2012-08-29

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

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

Fix information

Applicable component levels

  • RL00 PSN

       UP

  • RL00 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCQ88K","label":"Statistics Desktop"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"20.0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
29 August 2012