APAR status
Closed as program error.
Error description
You work with IBM SPSS Statistics 20 and import an Excel 2007/2010 XLSX file. In the Excel file you have variable names in the first row but one or more of the variable names are empty. For example you see variable names as below but the second name is empty in the Excel file: id <blank name> gender age value When you export this file into Statistics 20 you notice that all variable names after the blank variable names are replaced where you expected to have only the blank name replaced. id v2 v3 v4 v5 This was reported to IBM SPSS Development. As a workaround save your Excel file as Excel 2003 XLS format and import this file into Statistics or replace the blank names in Excel with valid names first. When you import the XLS file you would get: id v2 gender age value
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * Users importing Excel xlsx files * **************************************************************** * PROBLEM DESCRIPTION: * * You work with IBM SPSS Statistics 20 and import an Excel * * 2007/2010 XLSX file. In the Excel file you have variable * * names * * in the first row but one or more of the variable names are * * empty. For example you see variable names as below but the * * second name is empty in the Excel file: * * * * id <blank name> gender age value * * * * When you export this file into Statistics 20 you notice that * * all * * variable names after the blank variable names are replaced * * where * * you expected to have only the blank name replaced. * **************************************************************** * RECOMMENDATION: * * Install IBM SPSS Statistics 20 FixPack 1 (20.0.0.1) * ****************************************************************
Problem conclusion
Install IBM SPSS Statistics 20 FixPack 1 (20.0.0.1)
Temporary fix
Comments
APAR Information
APAR number
PM52737
Reported component name
SPSS STATISTICS
Reported component ID
5725A54ST
Reported release
K00
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-11-22
Closed date
2012-03-01
Last modified date
2012-03-01
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
RK00 PSN
UP
RK00 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:
01 March 2012