IBM Support

Original cell value is displayed in data view after sort of a variable

Flashes (Alerts)


Abstract

An issue has been identified in Statistics 19.0 where after a sort procedure, incorrect data is displayed and can be saved to the file.

Content

There are two situations that can cause this issue to occur:

  1. The user must sort using a right-click on variable name, choose ascending or descending order, then go into Variable View and do nothing, then go back to Data View, and save data using the same dataset name. In this scenario, the first cell of the sort variable will be the original value, while the rest of the variable and all other variables will be in sorted order.
  2. The user must have a cell selected, sort using syntax on that variable, then go into Variable View and do nothing, then go back to data view, and save data using the same dataset name. In this scenario, the selected cell will be in original order, while the rest of the variable and all other variables will be in sorted order.

This issue has been logged as APAR PM36208.

An interim fix is available that corrects this issue. Installation of Fix Pack 1 is a pre-requisite to applying the interim fix. Both the Fix Pack and the Interim Fix for this issue are available through Fix Central at http://www.ibm.com/support/fixcentral under Information Management

The fix will prevent the issue from occurring after it is applied but it will not correct any data that may already have been erroneously updated. In these situations, the data must be manually corrected.


The contents of this Alert is based on the best-available information as of the date of its publication. While every attempt has been made to provide guidance on the known issues at the time of publication, the Alert may not describe all of the circumstances under which the issue described above may occur, and may not provide a resolution for every occurrence of the issue. We continue to work to provide a comprehensive solution. All additional information will be documented in subsequent editions of this Alert and posted on the IBM website at http://www-947.ibm.com/support/entry/portal/Overview/

WARNING: Failure to follow these important instructions may result in incorrect values. You are responsible for implementing these changes to ensure that your system remains current with this alert. Under no circumstances is IBM or its suppliers responsible for loss of, or damage to, your data.

[{"Product":{"code":"SSLVMB","label":"IBM SPSS Statistics"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"19.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
25 September 2022

UID

swg21495869